举个例子看! Dim objPackage As DTS.Package2 Dim objStep As DTS.Step Dim objTask As DTS.Task Dim objExecPkg As DTS.ExecutePackageTaskOn Error GoTo PackageError Set objPackage = New DTS.Package Set mobjPkgEvents = objPackage objPackage.FailOnError = TrueSet objStep = objPackage.Steps.New Set objTask = objPackage.Tasks.New("DTSExecutePackageTask") Set objExecPkg = objTask.CustomTask With objExecPkg .ServerName = "服务器名称" .ServerUserName = "用户" .ServerPassword = "密码" .Name = "包名称" .PackagePassword = "包密码" End With With objStep .TaskName = objExecPkg.Name .Name = "ExecPkgStep" .ExecuteInMainThread = True End With objPackage.Steps.Add objStep objPackage.Tasks.Add objTaskobjPackage.ExecuteSet objExecPkg = Nothing Set objTask = Nothing Set objStep = Nothing Set mobjPkgEvents = NothingobjPackage.UnInitialize
SQL 标准包较通用
可以查看联机丛书
Dim objPackage As DTS.Package2
Dim objStep As DTS.Step
Dim objTask As DTS.Task
Dim objExecPkg As DTS.ExecutePackageTaskOn Error GoTo PackageError
Set objPackage = New DTS.Package
Set mobjPkgEvents = objPackage
objPackage.FailOnError = TrueSet objStep = objPackage.Steps.New
Set objTask = objPackage.Tasks.New("DTSExecutePackageTask")
Set objExecPkg = objTask.CustomTask
With objExecPkg
.ServerName = "服务器名称"
.ServerUserName = "用户"
.ServerPassword = "密码"
.Name = "包名称"
.PackagePassword = "包密码"
End With
With objStep
.TaskName = objExecPkg.Name
.Name = "ExecPkgStep"
.ExecuteInMainThread = True
End With
objPackage.Steps.Add objStep
objPackage.Tasks.Add objTaskobjPackage.ExecuteSet objExecPkg = Nothing
Set objTask = Nothing
Set objStep = Nothing
Set mobjPkgEvents = NothingobjPackage.UnInitialize