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