Link to home
Start Free TrialLog in
Avatar of rick
rick

asked on

SSIS - Mixed Mode Assembly Error

I'm trying to run a test SSIS package using DTEXEC.EXE.   The package, which ONLY has an Execute SQL in it, runs fine in Visual Studio Version 12.

When I run from command line using DTEXEC.EXE, i get the following error:  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

I've searched the web and found the suggestion to add useLegacyV2RuntimeActivationPolicy="true".  If that's true for me in SSIS, I do not know how to do it.
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Are you calling into a custom assembly from within your RDL -- I.e. does your RDL contain an explicit assembly reference? (The execution behavior can be different depending on whether you are running inside of VS or not.)
Avatar of rick
rick

ASKER

No assembly.  This is just a basic SSIS package with basically nothing in it, except an "Execute SQL" statement.  No coding at all.
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rick

ASKER

It is a version issue.  thank you