SQLTeam.com | Weblogs | Forums

Desktop Shortcut for user to run file import then a SQL script then file export


Basically just taking a csv file provided by a user, running a SQL script to make a lot of modifications and updates with temp tables then spitting a csv file out for them to import into ERP software. The ERP tool will take about 30 minutes to complete. When I run just using my local SQL environment, about 2 minutes. Ideally would just have a shortcut for the user that could run all that as SA without any user interaction or publicizing the SA password.


Create an SSIS package that they can run to do these steps. You can create a shortcut to it on their desktop by creating a cmd file that runs dtexec.


Thanks Tara, I will give that a shot.