Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DTSRunui.exe Expand / Collapse
Posted Wednesday, July 7, 2004 7:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 22, 2015 5:28 PM
Points: 58, Visits: 512


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:

\\<network share>\dtsrunui.exe /S TESTSVR04 /E /NImport asset changes



Post #125278
Posted Wednesday, July 7, 2004 9:36 PM



Group: General Forum Members
Last Login: Tuesday, November 29, 2016 1:45 PM
Points: 2,709, Visits: 1,427
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.

Hope this helps
Phill Carter
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #125285
Posted Saturday, July 10, 2004 4:55 PM


Group: General Forum Members
Last Login: Yesterday @ 6:23 PM
Points: 186, Visits: 533
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".
Post #125817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse