Application::ExistsOnSqlServer Method (String^, String^, String^, String^)


Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

bool ExistsOnSqlServer(
	String^ packagePath,
	String^ serverName,
	String^ serverUserName,
	String^ serverPassword


Type: System::String^

The package you are looking for.

Type: System::String^

The name of the instance of SQL Server to search for the package.

Type: System::String^

The user name to authenticate against the instance of SQL Server.

Type: System::String^

The password for the specified serverUserName.

Return Value

Type: System::Boolean

true if the package exists on the specified instance of SQL Server. false if the package does not exist.

The following code example creates a SQL Server folder, verifies that it exists, and then removes the folder and rechecks its existence. It also saves a package and verifies that the package was saved using the ExistsOnSqlServer 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

Return to top