When I try to run a SSIS package (built in SQL Server 2012, BIDS VS2010) from a console application built in .NET framework 4.0, I get the following error:
"The Execute method on the task returned error code 0x80131621 (Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.). The Execute method must succeed, and indicate the result using an \"out\" parameter.\r"
I was able to resolve the error by adding the attribute useLegacyV2RuntimeActivationPolicy="true" to the startup tag.
However, I don't understand the error as the SSIS package nor the console application is built using .NET Framework v2.0.
Can someone please explain what the error means?