Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DTSRunui.exe


DTSRunui.exe

Author
Message
Craig Stonehouse
Craig Stonehouse
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 512

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





philcart
philcart
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2748 Visits: 1434
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
corey lawson
corey lawson
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 544
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".
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search