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.