Execute DTS from MSAccess w/o setting reference

  • I need to allow some of my users the ability to fire off a DTS package from the SQL server (2000) without installing Enterprise Manager.  I'm giving them a button to push and I'm using late binding,

    Set objPkg = CreateObject("DTS.Package")

    because only a few of my users will be given this functionality and I don't want to distribute dll's to all pc's involved.  I'll just set up the one's that need it.

    Does anyone out there know the list of dll's required for this to work?  Anyone know of a good article on this?  Thanks...moonwatcher

  • You could kick off a command line process to DTSRUN.exe on a server that DTS is installed on...

    Type DTSRUNUI from a command prompt to generate the command string for you. This could be dynamically built in your access vba code.

     

    Hope that Helps

    Rob

  • Look at http://www.sqldts.com/default.aspx?225

    Russ

    PS:  As if you needed reassurance, I think that your plan will work very well.  I have done the same thing with other components.  It prevents users who don't need the functionality from getting errors using the normal Referenced dll strategy.  And I really  don't think that you will see significant performance problems.

    Russel Loski, MCSE Business Intelligence, Data Platform

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

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