February 26, 2015 at 5:35 pm
Dear all:
I need to write a Stored Procedure or SSIS package to export only new records with a time stamp from a table in SSMS to client's desktop.
How should I achieve that?
The requirement is to develop a web application that whenever the client wants to export the data they can click on the button and the file will be saved to their desktop.
My original thinking is to develop a SSIS package and set an auto job for the export.
My question is: for the SSIs package how should I configure for the destination path. Do I need to know the client's desktop information? Any suggestions?
Thank you for any inPut!
February 27, 2015 at 7:29 am
MaggieW (2/26/2015)
Dear all:I need to write a Stored Procedure or SSIS package to export only new records with a time stamp from a table in SSMS to client's desktop.
How should I achieve that?
The requirement is to develop a web application that whenever the client wants to export the data they can click on the button and the file will be saved to their desktop.
My original thinking is to develop a SSIS package and set an auto job for the export.
My question is: for the SSIs package how should I configure for the destination path. Do I need to know the client's desktop information? Any suggestions?
Thank you for any inPut!
In my opinion, this is not a task for either SSIS or a stored proc. Application code in the .NET framework (or any other web programming language for that matter) could easily allow an end user to click on a button and download a file, allowing the end user to specify the destination.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply