June 6, 2007 at 3:35 pm
Does anyone know how to execute a DTS package without being in Enterprise Manager?
I need the package because it moves data from a text file to a temp table in my db and then executes 4 stored procs to generate different reports.
But the idea is to give the package(s) to the final users so they can execute them (get me some free time) but without having to give them access to EM.
We were thinking on running it from a link on our intranet but I have no idea where to start.
Does anyone?
June 6, 2007 at 5:10 pm
There are instructions at sqldts.com for executing a package from T-SQL, ASP, C#, etc.
Personally, the only method I've used to allow users to trigger executtion of a package is to use a job to check a table that is updated by users. Here are some threads that describe this method:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=202222
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=16807
Greg
Greg
June 6, 2007 at 5:38 pm
Greg, thanks a lot for pointing me in the right direction!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply