Executing a DTS package from Sql Server 2005
- by Doerr
I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I have read is running a sql job from a stored procedure that calls the DTS package. Does anyone has any experience with this or know of a good way to call the DTS?
Note: For the forseeable future these packages will remain DTS. Eventually we will convert them to SSIS.
Any insight or experience would be very helpful.