Application.ExistsOnSqlServer メソッド
指定したパッケージが SQL Server のインスタンスに存在するかどうかを示す Boolean を返します。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Function ExistsOnSqlServer ( _
packagePath As String, _
serverName As String, _
serverUserName As String, _
serverPassword As String _
) As Boolean
'使用
Dim instance As Application
Dim packagePath As String
Dim serverName As String
Dim serverUserName As String
Dim serverPassword As String
Dim returnValue As Boolean
returnValue = instance.ExistsOnSqlServer(packagePath, _
serverName, serverUserName, serverPassword)
public bool ExistsOnSqlServer(
string packagePath,
string serverName,
string serverUserName,
string serverPassword
)
public:
bool ExistsOnSqlServer(
String^ packagePath,
String^ serverName,
String^ serverUserName,
String^ serverPassword
)
member ExistsOnSqlServer :
packagePath:string *
serverName:string *
serverUserName:string *
serverPassword:string -> bool
public function ExistsOnSqlServer(
packagePath : String,
serverName : String,
serverUserName : String,
serverPassword : String
) : boolean
パラメーター
- packagePath
型: System.String
検索対象のパッケージです。
- serverName
型: System.String
パッケージを検索する SQL Server のインスタンスの名前です。
- serverUserName
型: System.String
SQL Server のインスタンスに対して認証するユーザー名です。
- serverPassword
型: System.String
指定した serverUserName のパスワードです。
戻り値
型: System.Boolean
SQL Server の指定したインスタンスにパッケージが存在する場合は true です。パッケージが存在しない場合は false です。
使用例
次のコード例では、SQL Server フォルダーを作成し、このフォルダーの存在の確認、フォルダーの削除、および存在の再確認を行います。 また、パッケージを保存し、ExistsOnSqlServer メソッドを使用して、そのパッケージが保存されたことも確認します。
static void Main(string[] args)
{
// The variable pkg points to the location
// of the ExecuteProcess package sample
// that is installed with the SSIS samples.
string p = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
// Create a folder on SQL Server in the msdb database.
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", null, null);
// Verify that the folder exists by using ExistsOnSqlServer method.
Boolean folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", null, null);
Console.WriteLine("Folder exists? {0}", folderExists);
// Load a package and save it.
Package pkg = app.LoadPackage(p, null);
app.SaveToSqlServerAs(pkg, null, "newPkg", "yourserver", null, null);
// Verify that the package was saved.
Boolean packageExists = app.ExistsOnSqlServer("newPkg", "yourserver", null, null);
Console.WriteLine("Package exists? {0}", packageExists);
//Remove the folder.
app.RemoveFolderFromSqlServer("myNewFolder", "yourserver", null, null);
// Verify that the folder was removed by using the ExistsOnSqlServer method.
folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", null, null);
Console.WriteLine("Folder exists? {0}", folderExists);
}
Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim p 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()
' Create a folder on SQL Server in the msdb database.
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)
' Verify that the folder exists by using ExistsOnSqlServer method.
Dim folderExists As Boolean = app.FolderExistsOnSqlServer("myNewFolder","yourserver",Nothing,Nothing)
Console.WriteLine("Folder exists? {0}", folderExists)
' Load a package and save it.
Dim pkg As Package = app.LoadPackage(p,Nothing)
app.SaveToSqlServerAs(pkg, Nothing, "newPkg", "yourserver", Nothing, Nothing)
' Verify that the package was saved.
Dim packageExists As Boolean = app.ExistsOnSqlServer("newPkg","yourserver",Nothing,Nothing)
Console.WriteLine("Package exists? {0}", packageExists)
'Remove the folder.
app.RemoveFolderFromSqlServer("myNewFolder", "yourserver", Nothing, Nothing)
' Verify that the folder was removed by using the ExistsOnSqlServer method.
folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("Folder exists? {0}", folderExists)
End Sub
サンプル出力:
Folder exists? True
Package exists? True
Folder exists? False