SSIS Programming

  • Thread starter Thread starter zacks
  • Start date Start date
Z

zacks

Does anyone know how to reference a custom DLL in an SQL2005 SSIS
Package Script Task? The Add References dialog only has the .NET tab
for buildtin assemblies.
 
I'll assume you're talking about being able to add a reference to a
third-party assembly or a library assembly of your own, for use in a script
task.

First, give the assembly a strong name (requires a key file), and put it
into the global assembly cache (GAC).

Then, place a copy of it in this location:
%WINDIR%\Microsoft.Net\Framework\<the version of the framework you're
using>
such as:
C:\Microsoft.Net\Framework\V2.0.50727
for the 2.0 framework.

Open the Add References dialog and it should be there.

The reason you have to jump through these hoops is that the script task
actually uses Visual Studio for Applications (VSA), not the full-blown
development environment we're used to with Visual Studio. VSA was build as
an application enhancement tool, not a development environment.

HTH,
Tom Dacon
Dacon Software Consulting
 
One other thing - the best place to go for SSIS programming is
microsoft.public.sqlserver.intergrationsvcs

Tom Dacon
Dacon Software Consulting
 
Back
Top