Hi,

I was wondering if it is nessesary to use the statements 'begin transaction'
and 'commit transaction' in a sql task within a dts. I have a task where i
update some data, but i thought that if the dts fails the whole job will be
rolled back.

Is this true?

Nope

UPDATEs to data should be done through procs ideally.

You can have the package start a transaction and have a task join if
present. (Not everything can join though)

If you google on my name and transactions in DTS you should see how to
set this up.

Allan



"Jason" <jasonlewis (AT) hotrmail (DOT) com> wrote