Much thanks. Sorry I didn't mention, but yes, it is SQL 2000. Looks like I might not need to do anything with DTS though - we were very fixed on the idea that because this was a barcode application using specialized barcode printers, we would have to use the actual label software via activeX to print the labels - this is the piece that didn't allow the paramaterized queries necessitating the transform of one single row into a VFP table for the label software to access. The eureka came at a meeting today - Crystal Reports! It allows parameterized queries, the parameter(s) can be passed from VFP, plus CR can talk to SQL Server directly. A quick test with a label printer and it was decided. No more (high priced per-user) label software, just use runtime Crystal.
However, I am filing this away, never know when I might need it again!

Randy

>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.
>>>