SSIS Programming

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.
 
T

Tom Dacon

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
 
T

Tom Dacon

One other thing - the best place to go for SSIS programming is
microsoft.public.sqlserver.intergrationsvcs

Tom Dacon
Dacon Software Consulting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top