Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to Add reference in SSIS? RE: How to Add reference in SSIS?

  • May 7, 2010 at 6:56 am

    #1164046

    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/