running a DTS package from VB6

[DougP]

objPackage.LoadFromSQLServer("Michelle2", , , , , , , "DataWarehouseTest&quot

I snatched this from an earlier post and put it in my goodie bag folder.
Now I would like to run a DTS package myself

What else do I need above the objPackage. code line DIM it and SET it to something but what?

Dim objPackage as .....
Set objPackage = .....

TIA DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[LotusEater]

You have to reference the Microsoft DTSPackage Object Library;
ie Dim objPackage As DTS.Package
Set objPackage = New DTS.Package

LotusEater

 

[bigfoot]

Can this be done from the .NET world???