Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-02-18
1
Medium Priority
?
717 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

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ā€¦
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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
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.

610 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