DTSRunui.exe
-
Hi,
I'm trying to get the DTSRUNui.exe to run from a network share so that the user that need to run the DTS can run it with out having to install SQL tool on there PC. There are call the DTS command for a Call logging program that has the link to the server and when they run the command it is asking for all the DLL files that it uses. I've copyed three different DLL file and I would like to kwon what are all the DLL files that the DTSRUNui.exe uses?
The command is as follows:
\dtsrunui.exe">\\<network share>\dtsrunui.exe
/S TESTSVR04 /E /NImport asset changes
Thanks
Craig
-
Check BOL for the files that need to be distributed.
Although, why would you do this? Would be far easier to setup an ASP page for the user to run the package from. To save yourself some dramas, setup a scheduled job to run the package but don't give it a schedule. Then just run the job by calling sp_start_job from the ASP page.
--------------------
Colt 45 - the original point and click interface
-
DTSRunUI isn't redistributable, but of course, DTSRun is. You could script DTSRun in a VBScript.
It is also possible to add a couple of stored procedures to the database to run DTS packages from osql/isqlw. I found the code via google, but of course it's on my work computer...
try looking for "dts stored procedure t-sql".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply