The DTS package created by the DTS Import or DTS Export wizards can be saved to the Microsoft® SQL Server™ msdb database, Microsoft Repository, or a COM-structured storage file. Saving the DTS package allows it to be reused, or scheduled for later execution. If the DTS package is not saved, then it is executed immediately. The DTS package must be saved in order to schedule it for later execution.
Use these fields when saving the DTS package to the SQL Server msdb database.
| Use this | To do this | |
|---|---|---|
| Name | Specify a unique name for the DTS package. | |
| Description | Specify a description for the DTS package. | |
| Owner password | Specify a password for the DTS package to protect any sensitive username and server password information in the package from unauthorized users. | |
| User password | Set a password for a package user. This password allows a user to execute a package but not view the package definition. If you set the User password, you need to also set the Owner password. | |
| Server name | Specify the name of the SQL Server installation storing the DTS package. This option appears only when saving the package to SQL Server. | |
| Use Windows NT authentication | Specify the security mode used to connect to SQL Server. This option appears only when saving the package to SQL Server. | |
| Use SQL Server authentication | Specify the security mode used to connect to SQL Server. User Name and Password are required. This option only appears when saving the package to SQL Server. | |
| Username | Specify the login used to connect to SQL Server. This option only appears when saving the package to SQL Server. | |
| Password | Specify the password associated with User Name. This option only appears when saving the package to SQL Server. | |
Use these fields when saving the DTS package to Microsoft Repository.
| Use this | To do this | |
|---|---|---|
| Name | Specify a unique name for the DTS package. | |
| Description | Specify a description for the DTS package. | |
| Owner password | Specify a password for the DTS package to protect any sensitive username and server password information in the package from unauthorized users. | |
| User password | Set a password for a package user. This password allows a user to execute a package but not view the package definition. If you set the User password, you need to also set the Owner password. | |
| Server name | Specify the name of the SQL Server installation storing the DTS package. | |
| Scanning | Click to set the Repository scanning options for the package. This capability allows you to relate source and destination objects in a package to database metadata (for example, primary and foreign keys in a table, indexes, column information such as data type) stored in Repository. | |
| Use Windows NT authentication | Specify the security mode used to connect to SQL Server. | |
| Use SQL Server authentication | Specify the security mode used to connect to SQL Server. Username and Password are required. | |
| Username | Specify the login used to connect to SQL Server. | |
| Password | Specify the password associated with Username. | |
Use these fields when saving the DTS package to a COM-structured storage file.
| Use this | To do this |
|---|---|
| Name | Specify a unique name for the DTS package. |
| Description | Specify a description for the DTS package. |
| Owner password | Set a password for a package user. This password allows a user to execute a package but not view the package definition. If you set the User password, you must also set the Owner password. |
| User password | Specify a password for a user who is authorized to execute the package and to view general package object properties. |
| Server Name | Specify the name of the SQL Server installation storing the DTS package. |
| File name | Specify the package file name. |