Thursday 28 March 2013

SSIS on 64bit Dev machine

You have an "Execute SQL Task" to return a "Full result set" but when executing you get the following error.

[Execute SQL Task] Error: Executing the query "SELECT * FROM Table" failed with the following error: "Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Are you running on Windows 7 64bit? A possible fix if you are is to set the run time to 32 bit. You can do this by:
  1. Go to Project Properties
  2. Configuration Properties -> Debugging
  3. Set Run64BitRuntime False