Application.LoadPackage Метод

Определение

Пространство имен:

Microsoft.SqlServer.Dts.Runtime

Сборка:

Microsoft.SqlServer.ManagedDTS.dll

Загружает пакет.

Перегрузки

LoadPackage(String, IDTSEvents)	Загружает Package из файловой системы.
LoadPackage(String, IDTSEvents, Boolean)	Загружает Package из файловой системы и указывает потоковую модель.

LoadPackage(String, IDTSEvents)

Загружает Package из файловой системы.

public:
 Microsoft::SqlServer::Dts::Runtime::Package ^ LoadPackage(System::String ^ fileName, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ events);

public Microsoft.SqlServer.Dts.Runtime.Package LoadPackage (string fileName, Microsoft.SqlServer.Dts.Runtime.IDTSEvents events);

member this.LoadPackage : string * Microsoft.SqlServer.Dts.Runtime.IDTSEvents -> Microsoft.SqlServer.Dts.Runtime.Package

Public Function LoadPackage (fileName As String, events As IDTSEvents) As Package

Параметры

fileName

String

Имя файла, который содержит пакет для загрузки.

events

IDTSEvents

Интерфейс IDTSEvents.

Возвращаемое значение

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  

Образец вывода:

Number of configurations = 0

VersionGUID = Microsoft.SqlServer.Dts.Runtime.DtsProperty

ProtectionLevel = EncryptSensitiveWithUserKey

LoadPackage(String, IDTSEvents, Boolean)

Загружает Package из файловой системы и указывает потоковую модель.

public:
 Microsoft::SqlServer::Dts::Runtime::Package ^ LoadPackage(System::String ^ fileName, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ events, bool loadNeutral);

public Microsoft.SqlServer.Dts.Runtime.Package LoadPackage (string fileName, Microsoft.SqlServer.Dts.Runtime.IDTSEvents events, bool loadNeutral);

member this.LoadPackage : string * Microsoft.SqlServer.Dts.Runtime.IDTSEvents * bool -> Microsoft.SqlServer.Dts.Runtime.Package

Public Function LoadPackage (fileName As String, events As IDTSEvents, loadNeutral As Boolean) As Package

Параметры

fileName

String

Имя файла, который содержит пакет для загрузки.

events

IDTSEvents

Интерфейс IDTSEvents.

loadNeutral

Boolean

Логическое значение, указывающее, следует ли загружать пакет как нейтральный поток. Если значение равно false, загружает пакет в потоки в виде квартиры.

Возвращаемое значение

Package

Пакет, загрузка которого была выполнена.

Примеры

В следующем примере кода загружается пакет из файловой системы, задавая loadNeutral флаг false, а затем возвращается несколько свойств пакета.

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  

Образец вывода:

Number of configurations = 0

VersionGUID = Microsoft.SqlServer.Dts.Runtime.DtsProperty

ProtectionLevel = EncryptSensitiveWithUserKey