How can I execute a package with a package password in SSIS through code?

Question

I am trying to call an SSIS package through C # code. The package worked before I included the package password, but now I am trying to provide a password. I get an error that the password is incorrect or not specified.

Package package = app.LoadPackage("mypackage.dtsx, null); package.PackagePassword = "mypass"; DTSExecResult result = package.Execute(); 

Can someone please indicate where I am going wrong?

Answer 1

I believe this is what you need:

 app.PackagePassword = "mypass"; 

Answer 2

You must set a password before downloading the package, try the following:

 Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application(); app.PackagePassword = "mypass"; Package package = app.LoadPackage("mypackage.dtsx, null"); 

This will work; -)

Answer 3

 app.PackagePassword = "mypass"; Package package = app.LoadPackage("mypackage.dtsx, null);