Solved

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

Posted on 2011-02-18
1
676 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now