Hi Daniel,
Suppose I have a VFP app that set up a global variable and call the DTS. First of all I'm not sure what a global variable means in SQL world. But if it's a global variable, how will the DTS package handle the distinction between two users asking data trough the DTS at the same time with different parameters (different global variables values?).
Also, if it's not possible to programatically tell the DTS the name of the file to create, then, how my users knows which file is theirs? I don't want to end up with all the data in the same file as I've seen the DTS doing in my trials.
I suppose you see my point, there is no use to go on with a DTS avenue if these problems cannot be resolved.
I like your idea to fire a server base app from ASP. Can you tell me more about that, what the command would look like?
Thanks,
Diane Robitaille eng.