Can I use a trigger to launch a Data Transformation Services (DTS) package?
Yes, you can use a trigger to launch a DTS package in the following three ways:
- Scheduling the DTS package as an ad hoc job by using the sp_start_job stored procedure in msdb to fire the job from the trigger. This method has the advantage of providing resource governance because only one instance of the job can run at one time.
- Using the sp_Oa* system stored proc...