SuperSql
SuperSql

Reputation: 89

SSIS - "There was an error while building."

does anyone had this issue before? When I try to build a Script Component in SSIS but get the following error:

enter image description here

This does not give any context and actually it never starts the building so I don't know what is this.

Upvotes: 2

Views: 778

Answers (1)

Richard E
Richard E

Reputation: 11

I had this same error. In my case, I was using a dynamic variable. I was trying to convert the variable's value to Int32 on the line of code that triggered the error.

The fix was adding a reference to Microsoft.CSharp. Visual Studio thinks that the reference is not needed, but the script will not compile without it.

Thanks to C Woodward for the answer on dynamic data type not working in SSIS script task.

Upvotes: 0

Related Questions