Randy,
>Looks like I might not need to do anything with DTS though<<Darn! Just when I actually have something to contribute! < g >
Sounds like Crystal will do the job for you though ... glad you found a solution.
~~Bonnie
>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