Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling DTS Package
Message
 
To
30/05/2001 12:39:24
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00512750
Message ID:
00512790
Views:
11
Greg,

In the DTS designer (in SQL 2000 anyway) there is an icon for calling another DTS package (a box with blue arrows), the forth item down under the 'task' or it is #10 under the task drop down 'Execute Package tTask.'. Build the new DTS package, have it call the other DTS package.

I use this tecnique to mail the log of failed packages to me via the 'on failure' work flow.

HTH,
Doug
Douglas Osborne
Don't spend your life just wishing - http://www.AllGiftRegistry.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform