SSIS Script Transformation Error

0
votes

SSIS Script transformation is giving an error: The binary code for the script is not found.

Please open the script in the designer by clicking Edit Script button and make sure it

builds successfully"

I have opened the editor and rebuild ,but shows the error

Error 3 'Input0Buffer' does not contain a definition for 'Column1' and no extension method 'Column1' accepting a first argument of type 'Input0Buffer' could be found (are you missing a using directive or an assembly reference?)

2
c#c#-4.0ssisssis-2012script-component

2 Answers

4
votes

You have to make your input column available inside the script component (see the picture, in my case I made all columns available).

available input column from data stream

1
votes

You likely have a data column called Column1 in the data source that is feeding into your scripting component.

Check your data source / query that is coming into the scripting component and either remove that column1 field, or uncheck it so it doesn't feed into the scripting component.