• Article

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)

Syntax

'Declaration
Public Shared Function NewSqlStorage ( _
    host As String, _
    username As String, _
    password As String _
) As StorageInfo
'Usage
Dim host As String
Dim username As String
Dim password As String
Dim returnValue As StorageInfo

returnValue = StorageInfo.NewSqlStorage(host, _
    username, password)

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

public:
static StorageInfo^ NewSqlStorage(
    String^ host, 
    String^ username, 
    String^ password
)

static member NewSqlStorage : 
        host:string * 
        username:string * 
        password:string -> StorageInfo 

public static function NewSqlStorage(
    host : String, 
    username : String, 
    password : String
) : StorageInfo

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.

Remarks

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.