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

A "global variable" is a completely different animal in the DTS world. Basically, it is a value that is available for use between tasks (and even between DTS packages). More in just a bit...

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

My point is that it IS programatically possible to do this. DTS has a rich object model that allows you to alter tasks, change global variable values, bring up custom UI for input by users, and so forth. The object model is WAY too complex to go into here, but I will email you a couple of book suggestions.

>I suppose you see my point, there is no use to go on with a DTS avenue if these problems cannot be resolved.
>

DTS may not be the perfect solution, but I think it bears examination. Personally, I would be careful of allowing web users to trigger DTS operations, but perhaps you can let them FTP in their worksheets and have a SQL "sweeper" agent do the translations. It all depends on your business requirements.

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

I'm not a web guru but you can have ASP kick off DLL-based operations easy enough. I'll have to email you a sample.

Feel free to email me if you have more questions. I'd be very interested in helping you with this because I am working on a presentation regarding DTS. So the help is gratis (up to a point, of course!).