How to save a DTS package to SQL Server (Enterprise Manager)

To save a DTS package to SQL Server

1. In Data Transformation Services (DTS) Designer, on the toolbar, click the Save button.
   
   
2. In the Location list, click SQL Server.
   
   
3. Complete the rest of the required fields.

   Note  If the DTS package has already been saved to Microsoft® SQL Server™, the Save DTS Package dialog box will not appear and a new version will be saved. If the package has been saved to a structured storage or a Microsoft Visual Basic® file, or to SQL Server 2000 Meta Data Services, click Save As to save to SQL Server.

See Also

Saving a DTS Package to SQL Server