June 7, 2004 at 12:42 pm
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
June 8, 2004 at 5:28 am
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
June 8, 2004 at 8:43 am
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