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