How to Add reference in SSIS?

Question

How to Add reference in SSIS?

sqlusers

SSCrazy

Points: 2463
More actions
May 4, 2010 at 1:34 am

#146773

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!
---

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for aren't.

CEWII

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 2

Hi,

I do not understand.I can refer office assemblies but not data extensions,Presenataion Frameworks and many others....

Raunak J

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I believe those are registered in the GAC. I don't think that anything NOT registered in the GAC can be referenced in SSIS. Sorry.

CEWII

sqlusers SSCrazy Points: 2463 More actions · Answer 4

Elliott W (5/4/2010)
I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for aren't.
CEWII

Elliott,

Thanks for your reply.

Can you explain me how can we install our assemblies to GAC? So that, i can with the same.

Thanks!!

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

Maybe this will help:

http://msdn.microsoft.com/en-us/library/dkkx7f79%28v=VS.71%29.aspx

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

P Jones SSChampion Points: 12361 More actions · Answer 6

P Jones

SSChampion

Points: 12361

May 6, 2010 at 10:03 am

#1163401

Deleted

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

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.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 8

Cozy,

I think that is only true for custom SSIS components.

CEWII

COZYROC One Orange Chip Points: 28499 More actions · Answer 9

Elliott W (5/7/2010)
Cozy,
I think that is only true for custom SSIS components.
CEWII

Hmm,

I'm sorry I didn't understand what you mean? To reference third-party libraries you have to include them in the SDK/Assemblies as well. At least that is the case in SQL 2005. If you have SQL 2005, check the folder and you will understand what I mean. It contains mostly SSIS framework libraries.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 10

I was just looking at that and I don't think I agree. For Custom SSIS tasks, like the components you have written they DO need t be placed there AND in the GAC. However, if you look at the Paths in the Add Reference box they are in a couple different locations.

I might be interpretting things wrong but that is how I see it.

CEWII

jcebase67 Valued Member Points: 71 More actions · Answer 11

Thank you Ten Centuries, adding a copy of the dll's to the sql directory. That worked for me.