How to create a DTS package using DTS Designer (Enterprise Manager)
To create a DTS package using DTS Designer
- In the SQL Server Enterprise Manager console tree, right-click Data Transformation Services, and then click New Package.
Note Your choice of Local Packages or Meta Data Services Packages determines the format in which the file is saved by default (Local packages are saved to Microsoft® SQL Server™ and Meta Data Services packages are saved to SQL Server 2000 Meta Data Services).