Djabarov, Robert
Robert.Djabarov at usaa.com
Mon May 3 08:50:40 CDT 2004
DTS can be very elaborate and very uncontrollable at the same time. But if you store all the calls into a SQL Task within the package and structure each sp with proper error validation/error raising constructs, as well as return code validation after execution of each sp, - your package will be a smooth sailing. Robert Djabarov SQL Server & UDB Sr. SQL Server Administrator Phone: (210) 913-3148 Pager: (210) 753-3148 9800 Fredericksburg Rd. San Antonio, TX 78288 www.usaa.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of S D Sent: Monday, May 03, 2004 7:04 AM To: sqlserver667 Subject: [dba-SQLServer] DTS works like a transaction? 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com