How to Add reference in SSIS?

  • Hi,

    How to add references in SSIS? I need to add some office dll's to my SSIS package.

    In my SSIS script component, basically if i say Add Reference (in .NET tab) it is not showing office or other dll's. How can i import/add the dll's to my SSIS package?

    Please advice!

    ---

  • I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for aren't.

    CEWII

  • Hi,

    I do not understand.I can refer office assemblies but not data extensions,Presenataion Frameworks and many others....

    Raunak J

  • I believe those are registered in the GAC. I don't think that anything NOT registered in the GAC can be referenced in SSIS. Sorry.

    CEWII

  • Elliott W (5/4/2010)


    I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for aren't.

    CEWII

    Elliott,

    Thanks for your reply.

    Can you explain me how can we install our assemblies to GAC? So that, i can with the same.

    Thanks!!

  • Maybe this will help:

    http://msdn.microsoft.com/en-us/library/dkkx7f79%28v=VS.71%29.aspx

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Deleted

  • sqlusers (5/4/2010)


    Hi,

    How to add references in SSIS? I need to add some office dll's to my SSIS package.

    In my SSIS script component, basically if i say Add Reference (in .NET tab) it is not showing office or other dll's. How can i import/add the dll's to my SSIS package?

    Please advice!

    ---

    In addition to being registered in GAC, for SQL 2005 you have to deploy the library you want to reference in your script in this folder: Microsoft SQL Server\90\SDK\Assemblies

    Also make sure you have at least SQL 2005 SP2. Anything older than this is not working properly.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • Cozy,

    I think that is only true for custom SSIS components.

    CEWII

  • Elliott W (5/7/2010)


    Cozy,

    I think that is only true for custom SSIS components.

    CEWII

    Hmm,

    I'm sorry I didn't understand what you mean? To reference third-party libraries you have to include them in the SDK/Assemblies as well. At least that is the case in SQL 2005. If you have SQL 2005, check the folder and you will understand what I mean. It contains mostly SSIS framework libraries.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • I was just looking at that and I don't think I agree. For Custom SSIS tasks, like the components you have written they DO need t be placed there AND in the GAC. However, if you look at the Paths in the Add Reference box they are in a couple different locations.

    I might be interpretting things wrong but that is how I see it.

    CEWII

  • Thank you Ten Centuries, adding a copy of the dll's to the sql directory. That worked for me.

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

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