Share via


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 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.

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.

See Also

Reference

StorageInfo Class

Microsoft.SqlServer.Dts.Runtime Namespace