How to pass package password to DTEXEC while calling package using System.Diagnostics.Process.Start(process, args)
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)
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
Post a Comment