次の方法で共有

  • [アーティクル]

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

パラメーター

  • 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