Post reply

DTSRUNUI on non-SQL box

  • March 31, 2004 at 8:43 am

    #59200

    Hello, folks

    I need help on the following - We have a DTS package which loads data to a SQL database from a flat file (Blue Cross Blue Shield data).  People in accounting would like to maintain this database, loading updated information on a three-month cycle.

    We do not want to install MSDE on their local system, or give them rights to the server, but prefer to let them execute the DTS package via DTSRUNUI.  How do we install the DTSRUNUI to their local system?

    We can manually register the DLL files and copy the DTSRUNUI utility, but we would like to install it as a "package".  Does Microsoft have anythig like this?  I have searched their website but did not find anything. 

    Any assistance will be greatly appreciated.

    Charlies

     

  • April 1, 2004 at 8:05 pm

    #501542

    Are you sure you want to give them DTSRunUI?  Then they have access to all your packages, unless you password protect the other packages.

    I use a proc similar to the one by jgroseth  as referenced here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=19141#bm91009

    Then I simply give permission to execute the proc and they call the proc by clicking on a button in MS Access (But you could just as easily create a VB program with a button for each of the packages they can run).

    For sample code to run the proc, see my post here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=108681#bm108872 

     

    Bill

  • April 2, 2004 at 5:46 am

    #501581

    Thanks Bill.  I will try out the code this morning. 

    I appreciate the input and pointing me in the right direction.

     

    This is a GREAT site!! 

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply