Post reply

Error Loading Type Library/DLL

  • October 9, 2007 at 7:32 am

    #198880

    Hi,

    I have posted this question in several places and have yet to solve my problem. I have been directed to an MSDN article which said to register the following DLL to fix the problem:

    %windir%\system32\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\dts.dll

    I have registered this DLL a few times actually ... LOL... on the server and my client. The problem will not resolve.

    Can anybody please help me with this? Its sort of urgent...

    Running SQL Server 2005 SP2

    Thanks,

    Roxanne

  • October 9, 2007 at 9:19 am

    #740413

    It would help all of us if you posted what the actual problem is .....

    I have posted this question in several places and have yet to solve my problem.

    The problem will not resolve.

    😉

  • October 9, 2007 at 9:27 am

    #740417

    Umm.. I'm pretty sure I did tell you what the problem is... I'm getting Error Loading Type Library/DLL when I try to create DTS packages... what else would you like to know?

  • October 10, 2007 at 5:22 am

    #740695

    Nobody has any idea about this? Please I really need to fix it.

  • October 11, 2007 at 8:38 am

    #741229

    Really nobody has any idea why this would be happening when I try to create an SSIS package?

  • October 11, 2007 at 8:49 am

    #741237

    error loading DLL is a typical .NET error. it's pretty much one of 3 things:

    1. if you are running this on the server, the DLL is not in the folder, so it's not found and raises the error. so the folder \bin is calling a program or dll, and one of it's dependancies is not in the folder.

    2. the security context under which you are executing does not have permissions to the dll to execute it. the dll might exist, but the user does not have permissions to teh folder in which it resides.

    3. if it's accross a network, the security settings for the network prevent you from running the code over the network.the dll might exist on \\someotherserver\sharename , but the folder is not shared so that the security zone permissions to the folder are permitted.

    i think if you debug you'd get the full stack trace, and that would say explictly that something like the dependancy somedll.dll cound not be found

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 11, 2007 at 8:54 am

    #741239

    Hmm.. I don't think it is related to that... 🙁

    I have also ran the DLL registration command line on my client pc and on the server for DTS.dll and that did not solve the problem.

    1. The DLL is in the folder (at least I think its refering to DTS.dll) ... not sure what other DLL's should be in this folder?

    2. I am the admin of the server and the box its running on...

    3. Its not running across the network

    Thanks for the reply though.

  • October 11, 2007 at 9:36 am

    #741253

    it might not be dts.dll, it could be a dependancy that it happens to use.

    i went to my server and my sql 2005 express instance on my dev machine, but i don't have a \90\dts\binn\dts.dll folder on either of them. I was hoping to post the list of dlls in my folder so you could compare them to yours. I figured you might be missing a dll.

    plus, if it's a .net dll, it doesn't need to be registered or REGASM.exe 'd, just needs to exist in the same folder.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 11, 2007 at 9:57 am

    #741260

    well how do I know what dll it can't find?

    Is there some listing that deliniates what dll files get accessed when an SSIS package needs to be created?

  • November 30, 2009 at 10:37 am

    #1085549

    I'm having the same issue with SSIS, BIDS 2008.

    I'm at the point where I'm thinking to uninstall and re-install BIDS...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • November 30, 2009 at 10:45 am

    #1085561

    Wow, that post is so old! I can't remember what the problem was originally related to...but I believe I had to reinstall it. 🙂

  • November 30, 2009 at 10:50 am

    #1085566

    amy26 (11/30/2009)

    Wow, that post is so old! I can't remember what the problem was originally related to...but I believe I had to reinstall it. 🙂

    Then I'm on the right track... 🙂

    I've uninstalled VS 2005 and all of SQL 2005, and I am now also uninstalling BIDS 2008; I will re-install BIDS 2008 right after.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply