This topic has not yet been rated - Rate this topic

StorageInfo Class

SQL Server 2012

Provides information about the storage location for either the original or the upgraded Integration Services packages.

System.Object
Microsoft.SqlServer.Dts.Runtime.StorageInfo

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

Syntax

C++

JScript

public class StorageInfo

The StorageInfo type exposes the following members.

Properties

	Name	Description
	Host	Gets the name of the server on which either the original or the upgraded Integration Services packages are stored.
	RootFolder	Gets or sets the path for the folder that contains the subfolder to which Integration Services will back up the original Integration Services packages before upgrading them.
	ServerPassword	Gets the password that SQL Server authentication requires to connect to the SQL Server database that stores the original or the upgraded Integration Services packages.
	Type	Gets the type of storage that is used for either the original Integration Services packages or the upgraded packages.
	Username	Gets the user name that SQL Server authentication requires to connect to the SQL Server database that stores either the original or upgraded Integration Services packages.

Top

Methods

	Name	Description
	EnumeratePackagePaths	Returns a list of paths for the upgraded Integration Services packages in a given folder.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	NewFileStorage	Creates a new location on the file system in which the original or the upgraded packages will be stored.
	NewServerStorage	Creates a new Integration Services package store in which the original or the upgraded packages.
	NewSqlStorage	Creates a new Microsoft SQL Server database in which the original or the upgraded Integration Services packages will be stored.
	ToString	(Inherited from Object.)

Top

Remarks

One StorageInfo object for the original packages and one StorageInfo object for the upgraded packages is passed to the Upgrade method. For a code example that demonstrates how to upgrade packages, see the Upgrade method.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD