How to pass package password to DTEXEC while calling package using System.Diagnostics.Process.Start(process, args)


 i'm trying executea package via a script task in package - , whole process worked fine when using encryptsensitivewithuserkey - i'm using encryptsensitivewithpassword know need pass password process - can't figure our (or find) syntax anywhere. 

here current syntax.

args = "/file d:\ssisprojects\transportpad.dtsx /set \package.variables["parentpackagename"].properties[value];batchtransport" 

process = "c:\program files\microsoft sql server\90\dts\binn\dtexec.exe" 


system.diagnostics.process.start(process, args)

ssisnub said:

 i'm trying executea package via a script task in package - , whole process worked fine when using encryptsensitivewithuserkey - i'm using encryptsensitivewithpassword know need pass password process - can't figure our (or find) syntax anywhere. 

here current syntax.

args = "/file d:\ssisprojects\transportpad.dtsx /set \package.variables["parentpackagename"].properties[value];batchtransport" 

process = "c:\program files\microsoft sql server\90\dts\binn\dtexec.exe" 


system.diagnostics.process.start(process, args)


have checked dtexec documentation? have use:

/de[crypt] password

(optional). sets decryption password used when load package password encryption.


ssis tasks components scripts | http://www.cozyroc.com/


SQL Server  >  SQL Server Integration Services



Comments

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607