Pentru a executa un "DTS package" ai putea realiza o aplicatie foarte simpla in Visual Basic/VB.NET/C# folosind SQL-DMO (SQL Server 2000) sau SMO (SQL Server 2005).
http://www.sqldts.com/208.aspx
Pentru executia unui "DTS package" dintr-o procedura stocata:
How do I run a DTS package from the Query Analyzer or stored procedure?
Execute a DTS package from a SQL Server stored procedure
Execute DTS with input parameters from a SP