I have a problem when I need to specify a password when running my packages.
This article http://support.microsoft.com/kb/918760 says:
Method 3: set the SSIS package security property to EncryptSensitiveWithPassword
Change the SSIS PackageLevel security property to EncryptSensitiveWithPassword. This parameter uses the password for encryption. You can then change the command line of the SQL Server Agent job step to enable this password.
That sounds good and good. But where and how do you specify a password?
Here is an example of my current command line:
/ FILE "C: \ Program Files \ Microsoft SQL Server \ 100 \ DTS \ Packages
\ MainSSISPackage.dtsx "/ CONFIGFILE" C: \ Program Files
\ Microsoft SQL Server \ 100 \ DTS \ Packages \ DataConfig.dtsConfig "
/ CHECKPOINTING OFF / REPORTING E
source share