Save DTS Package
Use this dialog box to save a Data Transformation Services (DTS) package.
Specify a unique name for the package.
Specify a description for the package.
Specify a password for the package to protect any sensitive user name and server password information in the package from unauthorized users. This option is not available if you save to Microsoft® SQL Server™ 2000 Meta Data Services or to a Microsoft Visual Basic® file.
Specify 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 not available if you save to Meta Data Services or to a Visual Basic file.
Specify the name of the SQL Server installation storing the package.
Use Windows Authentication
Use Windows Authentication when saving a package to an instance of SQL Server. The Windows Authentication used will be the Microsoft Windows® login of the developer creating the package. If the package is scheduled through SQL Server Agent, the SQL Server Agent service must be run under an account that has permissions to access all the resources.
Use SQL Server Authentication
Use SQL Server Authentication when saving a package to an instance of SQL Server. If the package is scheduled through SQL Server Agent, the SQL Server Agent service account must have access to all the resources required by the package.
Specify the login used to connect to an instance of SQL Server if you clicked Use SQL Server Authentication.
Specify the password associated with the user name if you clicked Use SQL Server Authentication.
Display the Scanning Options dialog box, where you can 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, the following options are available:
- Specify a unique name for the package.
- Specify a description for the package.
- File name
- Specify the package source code file name and path. Click the browse (...) button to display the Save As dialog box.