Hello,
I'm working on a tool that creates SSIS packages which are necessary to upsize VFP data (dbf tables) into SQL server 2008.
Everything is working fine except the script components.
In SQL 2005 creating and compiling script component code wasn't that hard to accomplish, but here in SQL 2008 with the change from using VSA to VSTA I'm not able to generate valid script code anymore.
In some scenarios I have to insert a 'Script Component (Transformation)' between the Source and Destination Components.
If I do so and execute the SSIS package I get the following error message:
"Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is one class marked with SSISScriptComponentEntryPointAttribute in your script."
This attribute is set in code.
When I open the script from within SSMS and close it (no changes necessary) the whole package runs just fine.
So I assume that I'm not compiling it the way (currently using CodeDOM).
Researching the www I just found topics related to the 'Script Task' which is something completely different.
Do you have any ideas, advice, links, ... ?
Thanks for help!
robert.oh.