SSIS 2012 requires useLegacyV2RuntimeActivationPolicy attribute to Execute - by M Noreen

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 775991 Comments
Status Closed Workarounds
Type Bug Repros 6
Opened 1/7/2013 12:43:20 PM
Access Restriction Public


I have a c# based console app that loads and executs an SSIS package. This has been working great... until we upgraded from SQL 2008 R2 to SQL 2012.

I posted this on a forum site ( and it was suggested that I repost to Connect.  So here it goes:

After quite a bit of testing, I can reliably conclude there is an issue with SQL 2012's version of the ManagedDTS assembly.  Here's the short of what I did that lead me to that conclusion: 

In VS2012, I created a new C# console app, targeting the .NET 4 framework.  I referenced the ManagedDTS assembly that came with my SQL 2012 install. I recreated my load/execute code with a simple few lines, hard coding the path to a test SSIS package to load and execute.

Then I created a new, from-scratch SSIS package using SSDT (which ironically is based on VS2010, not VS2012).  I started with a simple package that had 2 connection managers.  One connection was wired up to my SQL 2012 test database and the other a flat file.  I added a simple Data Flow task to query some data straight out of a table and export it to a text file.

The package ran fine in SSDT.  Then, I ran my test console app to load and execute that test package as well.  And, it worked just fine (without the extra attribute being required in my new app.config).

In analyzing my original console app and package logged failures, I saw that it failed on the very first task in the package which was an Execute SQL Task.  So, in my new package, that I had verified was working, I added a new Execute SQL Task.  I set it up to execute a simple stored proc in my database. 
With that one additional task, my console app now failed when attempting to execute the package (with the same message about "mixed mode" issues).
I think the only logical conclusion here is that Microsoft must have compiled against a v2 reference... there is nothing I can do to "fix" this other than add the useLegacyV2RuntimeActivationPolicy attribute to my app.config.
Sign in to post a comment.
Posted by Microsoft on 3/22/2015 at 11:29 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.
Posted by The Oracle on 8/8/2014 at 2:21 PM
Hello? Anybody there?