Solved

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

Posted on 2011-02-18
1
688 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

691 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