How to save the DTS package to a SQL Server msdb table (Enterprise Manager)
To save the DTS package to a SQL Server msdb table
- In Data Transformation Services (DTS) Designer, on the Package menu, click Save.
- In the Package name box, type Northwind Package.
- In the Location list, click SQL Server.