StorageInfo.NewSqlStorage Method (String, String, String)

 

Creates a new Microsoft SQL Server database in which the original or the upgraded 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: System.String

The name of the server that stores the packages.

username
Type: System.String

The user name that SQL Server authentication requires to connect to the database.

password
Type: System.String

The string passwordthat 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 uses Windows authentication to connect to the server.

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

Return to top
Show: