SQLTeam.com | Weblogs | Forums

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


#1

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.
Thanks
Garry


#2

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.


#3

Thanks Tara, I will give that a shot.
Garry