I'm having trouble connecting to a SSIS server locally.
MSDTC has been down (due to low disk space) and I had to reset the log file.
The mean time I had MSDTC down, I re registered the DLL MsDtsSrvrUtil.dll.
This was doe to another error that I got while trying to connect to the SSIS server. ("connect to ssis service on machine failed no such interface supported")
Now i'm getting this new error:
"Connect to SSIS Service on machine failed: Error loading type library/DLL"
I'm running on SSIS 2005 (without SQL2005db) Do to the fact that I'm sharing the machine with a (hold your hats) SQL2000 instance.
OS: Windows 2003 standard sp2 x86
Which dll/typelib do I need to re register?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…