Application.ExistsOnDtsServer Method
SQL Server 2005
Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
public boolean ExistsOnDtsServer ( String sPackagePath, String sServerName )
public function ExistsOnDtsServer ( sPackagePath : String, sServerName : String ) : boolean
Parameters
- sPackagePath
The fully qualified path of the package.
- sServerName
The name of the server to search for the package.
Return Value
true if the package specified by sPackagePath exists on the server named by sServerName; otherwise, false.The following code example shows a package being saved to the File System under the parent folder, myFolder2. The example then checks if the package was saved by querying using the ExistsOnDtsServer method.
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 pkg = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"; Application app = new Application(); Package p = app.LoadPackage(pkg, null); // Save the package under myFolder which is found under the // File System folder on the DTS Service app.SaveToDtsServer(p, null, @"File System\myFolder2", "yourserver"); // Verify that the package was saved by // using ExistsOnDtsServer. Boolean packageExists = app.ExistsOnDtsServer(@"File System\myFolder", "yourserver"); Console.WriteLine("Package exists? " + packageExists); }
Sample Output:
Folder exists? True
Package exists? True
Folder exists? False
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.