Solved

Unable to connect to SSIS Service - library not registered.

Posted on 2008-11-01
11
1,936 Views
Last Modified: 2013-11-10
I'm unable to connect to SSIS. The message states "Library not registered".  I've gone into Add/Remove programs and changed my Integrated Services component but with no success.  Is it possible to uninstall SSIS only - I can't find how on the net.

Does anyone know how to resolve this problem?
0
Comment
Question by:BigBlackMamba
  • 6
  • 5
11 Comments
 
LVL 17

Expert Comment

by:HoggZilla
ID: 22858819
Do you have 2000 DTS and 2005 SSIS on the same machine.
0
 

Author Comment

by:BigBlackMamba
ID: 22858899
just 2005 ssis - i did download express 2008 but have since removed it.
0
 
LVL 17

Expert Comment

by:HoggZilla
ID: 22858998
I think you may be trying to connect in the Object Explorer in SQL Server Management Studio (SSMS). You need to open SSIS as follows: Start Menu, Microsoft SQL Server 2005, SQL Server Buisness Intelligence Development Studio. Then you create a new SSIS Project. In SSMS you are connecting to the Integration Services repository on a server, probably not what you really want to do.
0
 

Author Comment

by:BigBlackMamba
ID: 22859039
I realisei can do that but i need to be able to import DTSX packages built outside of BIDS and I know I can
do this via the Object Explorer. can i import via the route suggested? i'm new here - should be be posted as a second question?
0
 

Author Comment

by:BigBlackMamba
ID: 22859071
I've imported many packages using the following intructions given in on-line help:

"Open SQL Server Management Studio and connect to Integration Services.
In Object Explorer, expand the Stored Packages folder.

Expand the subfolders to locate the folder into which you want to import a package.

Right-click the folder, click Import Package. and then do one of the following:

To import from an instance of SQL Server, select the SQL Server option, and then specify the server and select the authentication mode. If you select SQL Server Authentication, provide a user name and a password.

Click the browse button (&), select the package to import, and then click OK.
To import from the file system, select the File system option.
Click the browse button (&), select the package to import, and then click Open.
To import from the SSIS Package Store, select the SSIS Package Store option and specify the server.
Click the browse button (&), select the package to import, and then click OK.

Optionally, update the package name.

To update the protection level of the package, click the browse button (&) and choose a different protection level by using the Package Protection Level dialog box. If the Encrypt sensitive data with password or the Encrypt all data with password option is selected, type and confirm a password.

Click OK to complete the import."

but this requires me to connect to Integated Services. I used to be able to do that but not any more....
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 17

Expert Comment

by:HoggZilla
ID: 22859118
Alright, you are further along than I presumed, very sorry. When you get the error, what is the full detail. Can you post the entire error?
obj-expl-is.bmp
0
 

Author Comment

by:BigBlackMamba
ID: 22859131
no problem and certainly no need to apologise; i appreciate your help. my sql server is TOASTER.

"Cannot connect to TOASTER

Additional Information

  Failed to retreive data for this request. (Microsoft.SqlServer.SmoEnum)

     Connect to SSIS Service on machine "TOASTER" failed:
         Library not registered.

            Connect to SSIS Service on machine "TOASTER" failed:
                Library not registered."
 
 
0
 
LVL 17

Accepted Solution

by:
HoggZilla earned 125 total points
ID: 22859208
Can you do a complete uninstall, there is no SSIS only option. Then reinstall? Is that an option?
0
 

Author Comment

by:BigBlackMamba
ID: 22859232
that's what I was afraid you might say - it's only a personal Server although I've written loads of T-SQL programs. Let me work out how to do a backup of my main database (and MASTER, MSDB) and I think I'll go down that route.  

If I can't do a backup, its not the end of the world; the programs are easily reproducible - the main thing is that SSIS works.

thanks for researching this for me.
0
 

Author Closing Comment

by:BigBlackMamba
ID: 31512376
thanks again for your help.
0
 
LVL 17

Expert Comment

by:HoggZilla
ID: 22859251
There are common occasions when dll 's need to be registered. I don't know why this happens, conflicts, installation bugs, etc.. But here is a link to a similar situation. Maybe it would help you. But I sure reccomend a reinstall of all SQL Server.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3999900&SiteID=17
Have you tried verifying the Service is running?
http://msdn.microsoft.com/en-us/library/ms137789(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms137731(SQL.90).aspx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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

707 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

15 Experts available now in Live!

Get 1:1 Help Now