CODEWITHSUNDEEP
c#ssis
eugene.it
eugene.it

Reputation: 447

SSIS Script transformation error CS0103 when using Output0Buffer class

I'm trying to help our dba by supplying script written with c#, so he can use it in his ScriptComponent.

I have an input file, process it line by line and create a row in Output0Buffer as it is explained in http://www.codeproject.com/Articles/441678/Getting-Started-With-SSIS-Script-transforms?fid=1765989&tid=4344144

I have written the test method and it works fine, however after inserting the logic inside of Input0_ProcessInputRow method as it's shown in the example, we are getting an error saying that Output0Buffer does not exist on the following lines:

    Output0Buffer.AddRow();
    Output0Buffer.Data = line;
    Output0Buffer.RegionName = regionName;

Error CS0103 The name 'Output0Buffer' does not exist in the current context

What are we missing here?

Upvotes: 6

Views: 12104

Answers (1)

eugene.it
eugene.it

Reputation: 447

I found why that happened. Basically, when creating the output, I changed its name explicitly to Output0Buffer and should have changed SynchronousInputID property to "None".

That did the trick.

This can be done by:

  • clicking on the Script Transformation Editor,
  • clicking the catagory Inputs and Outputs,
  • clicking on Output 0, and
  • changing SynchronousInputId to None in the right hand panel:

enter image description here

Upvotes: 16

Related Questions