To create a DTS package using DTS Designer
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).