How to specify a password on the SSIS package launch command line

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 
+4
source share
2 answers

How about this?

/ De [crypt] password

http://msdn.microsoft.com/en-us/library/ms162810.aspx

+10
source

Try the dtexec option

/ P [assword] password

0
source

Source: https://habr.com/ru/post/1305887/


All Articles