Hello,
The following blog will help users to deploy referenced dll in SSIS package while deploying to Integration Services.
Environment:
- SQL Server 2008
- Visual Studio 2008 (Business Intelligence Projects)
To add reference of any dll
in SSIS package, you go to project properties and browse to dll to add as a
reference. It should also be in your local machine GAC else it wont work.
SSIS project doesn’t have bin folder so it always look for assemblies from GAC.
Now to run on sql server (using Integration Services), the same dll
must be added to GAC on SQL Server machine.
Note: For assembly to be
added in GAC, it must have strong name.
HTH.
