Export (0) Print
Expand All

StorageInfo.NewSqlStorage Method

Creates a new Microsoft SQL Server database in which the original or the upgraded Integration Services packages will be stored.

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

public static StorageInfo NewSqlStorage(
	string host,
	string username,
	string password
)

Parameters

host
Type: String
The name of the server that stores the packages.
username
Type: String
The user name that SQL Server authentication requires to connect to the database.
password
Type: String
The string password that SQL Server authentication requires to connect to the database.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.StorageInfo
A StorageInfo object that specifies the SQL Server database.

If the username parameter is not set, Integration Services use Windows authentication to connect to the server.

If the username parameter is set, the password parameter must be set.

Community Additions

ADD
Show:
© 2014 Microsoft