Exception 0x80040154 generated while executing a s

Question

Hello I tried executing a simple SSIS package. Basicall I am reading a flat source file, sorting it on id and again writing in a new flat source file destination. But when I execute i get following exception:

TITLE: Microsoft Visual Studio

Failed to start project

---

ADDITIONAL INFORMATION:

Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (Microsoft.DataTransformationServices.VsIntegration)

I browsed through lot of forums and mostly they focused on 32-bit 64 bit issue and insisted on reinstalling the MS SQL server again. I am not sure about this exception since its a commonly generated error for different scenarios and issues. Just wanted to know if anybody has faced a similar issue before?

Answer 1

Take the .dtsx file and create a copy in another location. Create a new project and add this file to the new project. Try and run the package again.

Answer 2

The exception was being generated primarily because, I was trying to run a 32 bit SSIS package on 64 bit environment. So Solution for this to simply change one of the properties value "Run64BitRunTime" by setting it to false. You can find this in properties of solution present under solution explorer