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

ニュートラル スレッドとしてパッケージを読み込むかどうかを示す 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