SQL Server Performance Forum – Threads Archive

Redistribute DTS

I have an Excel file that uses the objects DTS.Package and DTS.Step. I therefore need to redistribute the relevant dll files to get it working. Now the following is taken from redist.txt on the SQL 2000 CD. When I attempt to register any of the 4 files I get an error of LoadLibrary Failed("dll name") – The specified module cannot be found. Any ideas? INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
———————————————————
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll Example: regsvr32 80ToolsBinndtsffile.dll The sqlunirl.dll file should reside in the system folder (i.e., winntsystem32 or windowssystem).

---

I don’t want you to think we are ignoring your post, but I don’t have the slightest idea how to answer your question. Hopefully some other member of the forum will have some idea. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com

---

Nor me im afraid! The only thing I can think of, is that there might be a bug whereby the path youre passing isnt taking effect. Try cd’ing into the actual dir (80ToolsBinn), and then running regsvr32 dllname, instead of passing the path.<br />Its a stab in the dark tho… <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br />

---

Well I still can’t fathom it but I’m working around the problem using DCOM instead. Thanks for the replies though as it’s always nice to hear someone else say "I don’t know either" <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />

---

]]>