Export (0) Print
Expand All

Application.LoadPackage Method (String, IDTSEvents, Boolean)

Loads a Package from the file system, and specifies the threading model.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

'Declaration
Public Function LoadPackage ( _
	fileName As String, _
	events As IDTSEvents, _
	loadNeutral As Boolean _
) As Package
public Package LoadPackage (
	String fileName, 
	IDTSEvents events, 
	boolean loadNeutral
)
public function LoadPackage (
	fileName : String, 
	events : IDTSEvents, 
	loadNeutral : boolean
) : Package

Parameters

fileName

The name of the file that contains the package to load.

events

An IDTSEvents interface.

loadNeutral

A Boolean that indicates whether to load the package as neutral threaded. If false, loads the package as apartment threaded.

Return Value

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
        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\90\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

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft