Executing a DTS package (SQL server)

[MattN]

I would like to execute a DTS package package using VB6.

Does anyone know the correct API to use.

A simple code example would be most appreciated.

Thanks in advance.

MattN

 

[Glasgow]

Assuming you have access to MSDN help, have a look at Package & Package2 objects and the Execute method under DTS programming.

 

[Glasgow]

And you will need to add Microsoft DTSPackage Object Library to your project references.

 

[paulbent]

To execute a package from a VB app, the SQL Server client components have to be installed on the PC running your app.

This installs a COM component, and you can set a project reference to "Microsoft DTSPackage Object Library". It then take a few lines of code to execute the package:

Set dtsPackage = New DTS.Package
dtsPackage.LoadFromSQLServer ServerName:="MyServer", _
ServerUserName:="MyUserID", _
ServerPassword:="MyPassword", _
PackageName:="MyPackage"
dtsPackage.Execute

You can also create packages at runtime using this object library if that's appropriate.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk