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

    😎