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 認証を使用している場合は、SQL Server ログイン名です。Windows 認証を使用している場合は、nullNothingnullptrunitNULL 参照 (Visual Basic では Nothing) です。
- serverPassword
型: System. . :: . .String
サーバーへのログインに SQL Server 認証を使用している場合は、SQL Server ログイン パスワードです。Windows 認証を使用している場合は、nullNothingnullptrunitNULL 参照 (Visual Basic では Nothing) です。
戻り値
型: 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