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?
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/