Hi Randy,

I've just started using the DTS object myself in VFP. This kb article does give you a good starting point (wish I had seen this last week < g >), but I want to point out that SQL2000 will be slightly different than SQL7 ... you didn't say which you were using.

The article shows:

loPackage = CREATEOBJECT('dts.package')

For SQL2000, you would want to use:

loPackage = CREATEOBJECT('dts.package2')

Also, as you may have already figured out, passing parameters is easy enough using GlobalVariables:

loPackage.GlobalVariables.Item('MyPassword').Value = 'bob'

What I had a hard time figuring out was how to find out whether the package executed ok or not. I finally settled on having the package set a GlobalVariable when it successfully completed which I can then check after the package executes.

Have fun!

~~Bonnie


>Excellent! Definitely a good start. Thanks.
>
>>Take a look at HOWTO: Execute a SQL Server 7.0 DTS Package from Visual FoxPro mskb #Q247356.
>>