title: Executing a DTS package from Sql Server 2005
body: <p>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? </p>
  
  <p>Note: For the forseeable future these packages will remain DTS. Eventually we will convert them to SSIS. </p>
  
  <p>Any insight or experience would be very helpful.</p>