Application.LoadPackage 方法 (String, IDTSEvents, Boolean)
Loads a Package from the file system, and specifies the threading model.
命名空间： Microsoft.SqlServer.Dts.Runtime
程序集： Microsoft.SqlServer.ManagedDTS（在 Microsoft.SqlServer.ManagedDTS.dll 中）
语法
声明
Public Function LoadPackage ( _
fileName As String, _
events As IDTSEvents, _
loadNeutral As Boolean _
) As Package
用法
Dim instance As Application
Dim fileName As String
Dim events As IDTSEvents
Dim loadNeutral As Boolean
Dim returnValue As Package
returnValue = instance.LoadPackage(fileName, _
events, loadNeutral)
public Package LoadPackage(
string fileName,
IDTSEvents events,
bool loadNeutral
)
public:
Package^ LoadPackage(
String^ fileName,
IDTSEvents^ events,
bool loadNeutral
)
member LoadPackage :
fileName:string *
events:IDTSEvents *
loadNeutral:bool -> Package
public function LoadPackage(
fileName : String,
events : IDTSEvents,
loadNeutral : boolean
) : Package
参数
- fileName
类型：System.String
The name of the file that contains the package to load.
- events
类型：Microsoft.SqlServer.Dts.Runtime.IDTSEvents
An IDTSEvents interface.
- loadNeutral
类型：System.Boolean
A Boolean that indicates whether to load the package as neutral threaded. If false, loads the package as apartment threaded.
返回值
类型：Microsoft.SqlServer.Dts.Runtime.Package
The package that was loaded.
示例
The following code example loads a package from the file system, setting the loadNeutral flag to false, and then returns several properties for the package.
class ApplicationTests
{
static void Main(string[] args)
{
// The variable pkg points to the location of the
// ExecuteProcess package sample installed with
// the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
Package p = app.LoadPackage(pkg, null, false);
// Now that the package is loaded, we can query on
// its properties.
int n = p.Configurations.Count;
DtsProperty p2 = p.Properties["VersionGUID"];
DTSProtectionLevel pl = p.ProtectionLevel;
Console.WriteLine("Number of configurations = " + n);
Console.WriteLine("VersionGUID = " + p2);
Console.WriteLine("ProtectionLevel = " + pl);
}
}
Class ApplicationTests
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location of the
' ExecuteProcess package sample installed with
' the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
Dim p As Package = app.LoadPackage(pkg,Nothing,False)
' Now that the package is loaded, we can query on
' its properties.
Dim n As Integer = p.Configurations.Count
Dim p2 As DtsProperty = p.Properties("VersionGUID")
Dim pl As DTSProtectionLevel = p.ProtectionLevel
Console.WriteLine("Number of configurations = " + n)
Console.WriteLine("VersionGUID = " + p2)
Console.WriteLine("ProtectionLevel = " + pl)
End Sub
End Class
Sample Output:
Number of configurations = 0
VersionGUID = Microsoft.SqlServer.Dts.Runtime.DtsProperty
ProtectionLevel = EncryptSensitiveWithUserKey