Save DTS Package
Use this dialog box to save a Data Transformation Services (DTS) package to the Microsoft® SQL Server™ msdb database, SQL Server 2000 Meta Data Services, a COM-structured storage file, or a Microsoft Visual Basic® file. You can also set package authentication information and passwords in this dialog box.
Options
When you are saving a package, the following options are available:
Package name
Specify a unique name for the package. The msdb tables use this name as a primary key.
Owner password
Specify a password for the package to protect any sensitive user name and server password information in the package from unauthorized users. If the package has an owner password, the data is encrypted with the standard encryption API. This option is available only for packages saved to SQL Server or as a structured storage file.
User password
Set a password for a package user. This password allows a user to execute a package. However, this option does not allow a user to view the package definition. If you set the user password, you also must set the owner password. This option is available only for packages saved to SQL Server or as a structured storage file.
Location
Specify the format and location of the saved package. You can save to a SQL Server msdb database, to Meta Data Services, to a structured storage file, or to a Visual Basic file.
When you save the package to SQL Server or to Meta Data Services, you have the following options:
Server name
Specify the name of the SQL Server installation storing the package.
Use Windows Authentication
Specify the security mode used to connect to SQL Server. The Windows Authentication used will be the Microsoft Windows® login of the user creating the package.
Use SQL Server Authentication
Specify the security mode used to connect to an instance of SQL Server.
User name
Specify a user name for the connection to an instance of SQL Server.
Password
Specify a password for the connection to an instance of SQL Server.
When you save the package to Meta Data Services, you have the following additional option:
Scanning
Display the Scanning Options dialog box, where you specify how objects referenced by the package should be scanned into Meta Data Services. This capability allows you to relate source and destination objects in a package to database meta data (for example, primary and foreign keys in a table, indexes, and column information, such as data type) stored in Meta Data Services.
When you save the package as a COM-structured storage file or a Visual Basic file, you have the following options:
File name
Specify the package file name and path. If the package is a structured storage file, it should be stored with the extension .dts. If the package is a Visual Basic file, it should be stored with the extension .bas.
Browse (...)
Display the Save As dialog box, where you can specify the file name, extension, and storage location.