February 26, 2015 at 5:48 pm
Dear all:
I need to write a stored procedure or SSIS to export data to client's desktop. What is the best way to achieve it?
The requirement is to develop a web application the client can click on the button and the file will be saved to the clients' local C drive.
How should I configure the destination path here?
Any idea?
February 26, 2015 at 11:05 pm
MaggieW (2/26/2015)
Dear all:I need to write a stored procedure or SSIS to export data to client's desktop. What is the best way to achieve it?
The requirement is to develop a web application the client can click on the button and the file will be saved to the clients' local C drive.
How should I configure the destination path here?
Any idea?
Quick thought, it is not possible in the way you are thinking here, the client has to initiate the download and select the download location, that is not the task for the web application. This is in fact just a normal download.
😎
February 26, 2015 at 11:34 pm
How to achieve that? And it's not a one-time thing. Every time there's new data in the DB, the clients need to click download and file will be saved
February 26, 2015 at 11:50 pm
The same way as any other download, the client initiates the download by clicking a link/button and the source of the file is the output of the stored procedure. Alternatively you can use SSIS to generate the files beforehand and just serve a link to the files.
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply