June 17, 2013 at 4:24 am
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!
June 17, 2013 at 4:47 am
Script tasks and script components are different things - which one do you mean?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 17, 2013 at 6:56 am
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.
June 17, 2013 at 7:11 am
Do you have SSIS installed too?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 17, 2013 at 7:38 am
Yes, SSIS is installed.
June 17, 2013 at 7:49 am
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 18, 2013 at 2:12 am
no worries. thanks for giving it a go. it may well be that my pc just needs a rebuild.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply