How to save a DTS package to SQL Server (DTS Designer)

To save a DTS package to SQL Server

1. Click Save on the toolbar.
2. In the Save DTS Package dialog box, in Location, click SQL Server.
3. Complete the rest of the required fields.