Solved

Connect to SSIS Service on machine ... failed:   Error loading type library/DLL

Posted on 2011-02-18
1
684 Views
Last Modified: 2012-05-11
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?

*I DO NOT WAN'T TO REINSTALL SSIS*
0
Comment
Question by:jonaska
1 Comment
 
LVL 6

Accepted Solution

by:
jonaska earned 0 total points
ID: 34924187
Solved it by re registering the dts.dll
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connect to an SQL server ActiveX 10 29
Download ms sql express. 2 29
query linked sql table field from access 4 27
too many installs coming along with SQL 2016? 1 19
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question