Application Methods

Public Methods

(see also Protected Methods )

	Name	Description
	CreateFolderOnDtsServer	Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy.
	CreateFolderOnSqlServer	Creates a folder on the specified instance of SQL Server.
	DataTypeInfoFromDataType	Returns the DataTypeInfo object for the specified data type. This method is not CLS-compliant.
	Equals	Overloaded. (inherited from DtsObject )
	ExistsOnDtsServer	Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
	ExistsOnSqlServer	Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
	FolderExistsOnDtsServer	Returns a Boolean that indicates whether the specified folder already exists on the file system.
	FolderExistsOnSqlServer	Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
	GetDtsServerPackageInfos	Gets a PackageInfos collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder.
	GetDtsServerRoles	Returns an array of Strings that lists the roles available for a folder.
	GetHashCode	Returns the hash code for this instance. (inherited from DtsObject )
	GetPackageInfos	Gets a PackageInfos collection that contains the packages stored in an instance of SQL Server, within the specified logical folder, by using the server name, user name, and password.
	GetPackageInfos2
	GetPackageRoles	Returns the database roles that have read access and write access to the package. Database roles apply only to packages stored in the SQL Servermsdb database.
	GetRunningPackages	Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.
	GetServerInfo	Returns the SQL Server version number of the SQL Server product installed on the target server.
	GetServerVersionEx	Returns the edition, product level, and other values that indicate the version of SSIS installed.
	GetType	(inherited from Object )
	LoadFromDtsServer	Loads a package from the specified server.
	LoadFromSqlServer	Loads a package from SQL Server by specifying the server name, user name, and password.
	LoadFromSqlServer2
	LoadPackage	Overloaded. Loads a package.
	op_Equality	(inherited from DtsObject )
	op_Inequality	(inherited from DtsObject )
	ReferenceEquals	(inherited from Object )
	RemoveFolderFromDtsServer	Removes the specified folder from the specified server.
	RemoveFolderFromSqlServer	Removes the specified folder from the specified instance of SQL Server.
	RemoveFromDtsServer	Removes a package from the specified server.
	RemoveFromSqlServer	Removes a package from the specified instance of SQL Server.
	RenameFolderOnDtsServer	Renames a folder on the specified instance of SQL Server.
	RenameFolderOnSqlServer	Renames a folder on the specified instance of SQL Server.
	SaveToDtsServer	Saves a package to the file system.
	SaveToSqlServer	Saves a package to an instance of SQL Server.
	SaveToSqlServerAs	Saves a package to an instance of SQL Server with a new name.
	SaveToXml	Saves the XML definition of a package to a file.
	SetPackageRoles	Sets the database roles that have read access and write access to the package. Database roles apply only to package stored in the SQL Servermsdb database.
	ToString	(inherited from Object )

Protected Methods

	Name	Description
	Finalize	(inherited from Object )
	MemberwiseClone	(inherited from Object )

See Also

Reference

Application Class
Microsoft.SqlServer.Dts.Runtime Namespace