What assemblies do i need to add to my SSIS Project?

Question

What assemblies do i need to add to my SSIS Project?

winston Smith

SSCoach

Points: 19500
More actions
June 17, 2013 at 4:24 am

#146179

I just inherited an SSIS package with a script component but it seems to be missing a bunch of assemblies.
It reads in a CSV txt file, takes each line, splits it into the individual entries and outputs each row which is sent to an OLEDB Destination.
Problem is the script task doesn't work as im missing a few assemblies. from my error messages Im missing:
Microsoft.SQLServer.Dts.Pipeline.PipelineBuffer
Microsoft.SqlServer/DTSRuntime.Wrapper.IDTSVariables100
In the script task I can see the following imports that don't see to work:
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime
I have sql server 2008 R2 installed, with the dev tools (BIDS) and assumed all required assemblies would be installed and registered but that's no the case and so I need help identifying the dll's to register and import into my project.
Any help would be appreciated!
Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

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

Phil Parkin SSC Guru Points: 246965 More actions · Answer 1

Script tasks and script components are different things - which one do you mean?

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

winston Smith SSCoach Points: 19500 More actions · Answer 2

Thanks! I didn't know that, really good to know.

The item in question is a Script Component, and it is set as a transformation.

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

Do you have SSIS installed too?

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

winston Smith SSCoach Points: 19500 More actions · Answer 4

winston Smith

SSCoach

Points: 19500

June 17, 2013 at 7:38 am

#1624588

Yes, SSIS is installed.

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

Running out of ideas, I'm afraid. You are right in thinking that there is not normally any need to mess about with built-in assemblies.

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

winston Smith SSCoach Points: 19500 More actions · Answer 6

no worries. thanks for giving it a go. it may well be that my pc just needs a rebuild.