Hi All,

I am using some 'Execute SQL Task's and fire some stored proc from it, and I
need transaction in it.
should I still handle transaction Commit Rollback in stored proc ?
Or is it enough to handle Transaction in the Task's workflow properties ?

Thank you for your help,
Trist

Does the transaction need to span more than this task?

If so the read the section in Books Online about using DTS transactions,
and yes you will then need to set the task/step level or package level
options.

If the transaction is only within the one task, then just normal T-SQL
transaction statements and appropriate syntax. It will have less overhead,
and be easier to manage.


--
Darren Green
http://www.sqldts.com


"tristant" <krislioe (AT) cbn (DOT) net.id> wrote