While working with the script component in SSIS, sometimes we may run into the below warning.
Warning XX ‘ScriptMain’ is not CLS-compliant because it derives from ‘UserComponent’, which is not CLS-compliant.
And an error like,
Error XX Validation error.DdataFlowTaskName Script Component : Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is one class marked with SSISScriptComponentEntryPointAttribute in your script. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent()
This basically happens because “UserComponent” that we inherit from is not CLS (Common Language Specification) compliant. As per MSDN “A class or interface is marked as <CLSCompliant(True)> when it derives from or implements a type that is marked as <CLSCompliant(False)> or is not marked.”
So, this issue can be easily rectified easily by adding the below code near the ‘ScriptMain’ line
Public Class ScriptMain
And also just check the number of input columns being passed and if there are any duplicate columns getting into the script component. This should resolve the issue being faced.