sql server dts: sql task -- sql server dts

sql task

Jason
4/13/2005 1:23:16 PM

sql server dts: 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?

Re: sql task

Allan Mitchell
4/13/2005 6:24:42 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.