如何通过代码在SSIS中使用包密码执行包? [英] How can I execute a package with a package password in SSIS through code?

问题描述

我正在尝试通过 C# 代码调用 SSIS 包.该包在我设置包密码之前工作，但现在我正在尝试提供密码我收到一个错误，提示密码错误或未提供.

I'm trying to call an SSIS package through C# code. The package worked before I put a package password on, but now I'm trying to supply the password I'm getting an error that the password is wrong or not supplied.

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

            DTSExecResult result = package.Execute();

谁能指出我哪里出错了?

Can anyone point out where I'm going wrong?

推荐答案

我相信这就是您所需要的:

I believe this is what you need:

app.PackagePassword = "mypass";

这篇关于如何通过代码在SSIS中使用包密码执行包?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！