Creating dynamic text file from ASP page ( need direction)

[ssumpter]

I am somewhat new to DTS packages - please bear with me...

:: Overview:
From a web page, I need to create a text file on a User's mapped drive drive (note: the mapped drive is always the same and it is a drive that the IIS cannot see, and FTP is not an option here). One of the parameters I need to pass from the web page (to the DTS) is the text file name.

Currently, I have a stored procedure that creates my dataset for my text file, and I can create the text file from the web page onto the IIS server, but this does not solve my problem.

My dilemma is how do I create the dynamic text onto the mapped drive? The SQL server CAN see the mapped drive.

Can I bring together what the Stored Procedure creates AND pass thru the dataset and the dynamic name to a DTS so it can create and save the file?

Can the Stored Procedure be eliminated and it all be done via DTS?

What about passing in parameters directly to a DTS from the web page? I'm not finding much help on this portion

Any help and/or direction would be appreciated as I am on a tight deadline!

 

[sjuarez1979]

Creating files on the clients machine through a web app is generally a nono. Couldnt you simply output text and then open the text file on the server side?

Algorithm:
1. Create dataset to ouput
2. Use ASP FileSystemObject to write to txt file
3. Response.Redirect to newly created text file
4. Client chooses to save the file or not

Seth Juarez
Technology Consultant