开发者

How to specify a password on the command line of an SSIS package run

I am having an issue where I need to be able to specify the password when I run my packages.

This article http://support.microsoft.com/kb/918760 says:


Method 3: Set the SSIS Package ProtectionLevel property to EncryptSensitiveWithPassword

Change the SSIS Package ProtectionLevel property to EncryptSensitiveWithPassword. This setting uses a password for encryption. You can then modify the SQL Server Agent job step command line to include this password.


That all sounds well and good. But where and how to you specify the password?

Here is an example of my curren开发者_如何学Ct 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


What about this?

/De[crypt] password 

https://learn.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-ver16


/FILE "\"E:\SSIS\New folder\test\test\Package.dtsx\"" /DECRYPT  password /CHECKPOINTING OFF  /REPORTING E


Try dtexec option

/P[assword]password
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜