- Posted by justin on September 28, 2004
While researching running dts package during my nant builds I ran across some intersting sql articles/code.
Cookbook for using SQL Server DTS 2000 with .NET - Tells you how to execute a dts package in .NET Code
ScriptJobs - ScriptJobs is a vbscrpit that uses SQL-DMO to script out all sql jobs or a single job at the time, identified by name or ID.
Save DTS Package to File -SQL Utility that comes with SQL2k that can be used to store a dts package to a file.
Execute DTS Package using VB.NET/C#/C++
Good list of MS SQL Information
Programatically Save DTS Packages to Files using DTSRUN
Save all DTS Packages to Files using T-SQL and sp_OA
Load DTS File to SQL Server
DTS and C#
DTS Package2 Hierarchy
After much search I found that to delete a DTS package from SQL you can use the dtsrun command and the /!D option.