Hum, I'll have to read more about DTS but I'm not sure it'll do what I want. I'm not exporting the content of one table or portion of it. I have a little script that prepare the data into a temporary table and from there I want to export the results outside of SQL. Ideally I want to be able to call this function from an outside program (actually a .asp page).
Will DTS work? Am I loosing my time trying to learn DTS to do this task? Can a DTS be called outside of SQL? Like, can VFP call a DTS to run? Or maybe a DTS can be call within a store procedure?
Don't need to explain all, just tell me if DTS is the thinkg I should learn.
Actually, I'm looking for a function like the VFP function : "copy to .... type ....". I'm starting to think it won't be that simple!
Thanks.
Diane Robitaille eng.