Application.LoadPackage メソッド (String, IDTSEvents, Boolean)
ファイル システムから Package を読み込み、スレッディング モデルを指定します。
名前空間: 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
読み込むパッケージを含むファイルの名前です。
- events
型: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
IDTSEvents インターフェイスです。
- loadNeutral
型: System.Boolean
ニュートラル スレッドとしてパッケージを読み込むかどうかを示す Boolean です。 false の場合に、アパートメント スレッドとしてパッケージを読み込みます。
戻り値
型: Microsoft.SqlServer.Dts.Runtime.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