[dba-SQLServer] DTS works like a transaction?

S D sqlserver667 at yahoo.com
Mon May 3 07:04:20 CDT 2004


Hi group,
 
I'm creating an impact analysis for my first really big SQL server project.
I need to fire a lot (30+) sp's. I want to do this using a DTS package. I think a job is not intended for this and a job is too slow.
 
Question regarding DTS:
Does a DTS work like a transaction?
So if one SP fails will all actions rollback?
 
TIA
 
Sander

		
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs 


More information about the dba-SQLServer mailing list