Reputation: 89
does anyone had this issue before? When I try to build a Script Component in SSIS but get the following error:
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
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