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.