Hi everyones,
Here's something I want to do and I need some ideas on how to do it.
I'm in a web base application, so it is multi-users, possibly many at the same time. I wan teach user to be able to ask and download an excel file (or a txt file) from the web server. The file contains information taking out of a SQL database. The data in the file is different depending on the user input parameters.
Example:
User A ask for the sales between 2004/01/01 and 2004/03/31 for department AA
User B ask for the sales between 2003/01/01 and 2003/12/31 for department BB
I'm thinking of using a DTS package but there are things I'm unsure how to do.
Keep in mind that both user could make their request at the same time, each must receive his file containing only his information. I don't know how to :
1) How to pass the dates and department to the DTS package.
2) How to create files with different names. One unique name for each user.
I use ASP pages, but I'm not familiar with all ASP capabilities. Maybe I should do it in ASP? Can I create a txt file from ASP?
Any ideas are wellcome.
Diane Robitaille eng.