此 API 支持 SQL Server 2012 基础结构,但不能通过代码直接使用。
Gets a IDTSPackageInfos100 collection that contains the packages stored in an instance of SQL Server, within the specified logical folder, by using the server name, user name, and password.
命名空间: Microsoft.SqlServer.Dts.Runtime.Wrapper
程序集: Microsoft.SqlServer.DTSRuntimeWrap(在 Microsoft.SqlServer.DTSRuntimeWrap.dll 中)
语法
声明
Function GetPackageInfos ( _
bstrPackageFolder As String, _
bstrServerName As String, _
bstrServerUserName As String, _
bstrServerPassword As String _
) As IDTSPackageInfos100
用法
Dim instance As IDTSApplication100
Dim bstrPackageFolder As String
Dim bstrServerName As String
Dim bstrServerUserName As String
Dim bstrServerPassword As String
Dim returnValue As IDTSPackageInfos100
returnValue = instance.GetPackageInfos(bstrPackageFolder, _
bstrServerName, bstrServerUserName, _
bstrServerPassword)
IDTSPackageInfos100 GetPackageInfos(
string bstrPackageFolder,
string bstrServerName,
string bstrServerUserName,
string bstrServerPassword
)
IDTSPackageInfos100^ GetPackageInfos(
[InAttribute] String^ bstrPackageFolder,
[InAttribute] String^ bstrServerName,
[InAttribute] String^ bstrServerUserName,
[InAttribute] String^ bstrServerPassword
)
abstract GetPackageInfos :
bstrPackageFolder:string *
bstrServerName:string *
bstrServerUserName:string *
bstrServerPassword:string -> IDTSPackageInfos100
function GetPackageInfos(
bstrPackageFolder : String,
bstrServerName : String,
bstrServerUserName : String,
bstrServerPassword : String
) : IDTSPackageInfos100
参数
- bstrPackageFolder
类型:System.String
The logical folder that contains the packages you want to enumerate.
- bstrServerName
类型:System.String
The name of the SQL Server instance where the packages reside.
- bstrServerUserName
类型:System.String
The account name used to log on to the instance of SQL Server, if you need to log in to SQL Server using standard authentication. If you are using Windows Authentication, use nullnull 引用(在 Visual Basic 中为 Nothing).
- bstrServerPassword
类型:System.String
The password of the user account, if you need to log in to SQL Server using standard authentication. If you are using Windows Authentication, use nullnull 引用(在 Visual Basic 中为 Nothing).
返回值
类型:Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageInfos100
A IDTSPackageInfos100 collection that contains IDTSPackageInfo100 objects.