| SQL Server Setup Help | |
| Migrating Passwords | |
See Also
|
|
|
| Upgrading SQL Server Components > Upgrading or Migrating Data Transformation Services > Migrating Data Transformation Services Packages > |
SQL Server 2005 only uses passwords on packages in connection with certain package protection level options. Therefore, password-protected packages that are fully migrated from SQL Server 2000 to SQL Server 2005 do not retain passwords, although you must provide the password during the migration process. For information about package protection levels in SQL Server 2005, see Setting the Protection Level of Packages.
 Note: |
|---|
| Password-protected packages cannot be migrated unless you provide their passwords. |
If the DTS run-time engine for SQL Server 2000 is installed, you can continue to run SQL Server 2000 packages. You can also include these packages in SQL Server 2005 data transformation solutions. SQL Server 2005 continues to support package passwords in this scenario. For example, the Execute DTS 2000 Package task includes a password property for passing a password to a SQL Server 2000 package.
Adding Security Features to Packages
After a package is migrated, you can add the following security features:
-
Set the protection level on the package to encrypt all or only sensitive property values when the package is saved. For more information, see DTS Package.
-
Digitally sign the package and set properties to ensure that the signature is checked when the package is loaded. For more information, see How to sign a DTS package.
-
Encrypt checkpoints on packages that use checkpoints. For more information, see Using Checkpoints in Packages.
For more information about securing the Integration Services service and Integration Services packages, see Security Considerations for Integration Services.