Looking for information on running ssisUnit in 32 bit mode


I have a number of packages that read Excel files that I am attempting to create automated tests for. I keep running into the problem of running the package in 64-bit mode. I've set everything in BIDS to have the Run64BitRuntime = False but that does not seem to solve the issue. Has anyone come across a solution for this? I was thinking maybe something for the ssisUnitTestRunnerUI2008.exe.config file. Or maybe setting it to 32-bit mode with CorFlag. Any thoughts?

file attachments


f3ar87 wrote Feb 13, 2014 at 1:24 PM

Hi, any news about this feature?

johnwelch wrote Feb 13, 2014 at 4:20 PM

You'd need to compile the ssisUnitTestRunner in 32-bit mode - change the platform in the project properties to x86. You can do this using Visual Studio Express.

I've attached a version I just compiled as 32-bit, if you want to try it out.