ScriptComponent Transformation Error
Hello , I am working on a script component Transformation in my mapping.In my script ,I do not see any errors But my script component is giving an and I am not able figure where the error is coming from. Here is the error Error 20 Validation error. TASKTABLE. Script Component [34282]: Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component using class name "ScriptComponent_0a37647ba8c54a3885b8bbb1ef37d4f0.ScriptMain". at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent() TASKTABLE.dtsx 0 0 Please can some one help what the error might be?. Thank you.
June 10th, 2011 10:24am

Sometimes it is just faster to drop and re-create a component, looks like you have the case with yours. So delete and re-do it (seems some sort of corruption happened).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 11:30am

I have recreated the script component , even then It shows the same error. I am not really confused what would be the problem. Please help me. Thanks
June 10th, 2011 11:36am

Did you try to click "Build" menu item in the script component's editor window? Do you receive any errors if you do so?Daniel Cai | http://danielcai.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 2:06pm

I have recreated the script component , even then It shows the same error. I am not really confused what would be the problem. Please help me. Thanks Check for build errors like Daniel mentioned or check if there is a red cross on your Script Component.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
June 10th, 2011 3:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics