Application.LoadPackage Method (String, IDTSEvents)
Loads a Package from the file system.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Function LoadPackage ( _
fileName As String, _
events As IDTSEvents _
) As Package
'Usage
Dim instance As Application
Dim fileName As String
Dim events As IDTSEvents
Dim returnValue As Package
returnValue = instance.LoadPackage(fileName, _
events)
public Package LoadPackage(
string fileName,
IDTSEvents events
)
public:
Package^ LoadPackage(
String^ fileName,
IDTSEvents^ events
)
member LoadPackage :
fileName:string *
events:IDTSEvents -> Package
public function LoadPackage(
fileName : String,
events : IDTSEvents
) : Package
Parameters
- fileName
Type: System.String
The name of the file that contains the package to load.
- events
Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
An IDTSEvents interface.
Return Value
Type: Microsoft.SqlServer.Dts.Runtime.Package
The package that was loaded.
Examples
The following code example loads a package from the file system, 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);
// 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)
' 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