Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTSRunui.exe Expand / Collapse
Author
Message
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: Thursday, October 16, 2014 6:15 PM
Points: 58, Visits: 508

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:

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

Thanks

Craig




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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 16, 2014 6:41 PM
Points: 2,693, Visits: 1,219
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:37 AM
Points: 157, Visits: 375
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