Export (0) Print
Expand All

Application.ExistsOnDtsServer Method

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)

public function ExistsOnDtsServer(
	sPackagePath : String, 
	sServerName : String
) : boolean

Parameters

sPackagePath
Type: System.String
The fully qualified path of the package.
sServerName
Type: System.String
The name of the server to search for the package.

Return Value

Type: System.Boolean
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.

No code example is currently available or this language may not be supported.

Sample Output:

Folder exists? True

Package exists? True

Folder exists? False

Community Additions

ADD
Show:
© 2014 Microsoft