question

leonid18 avatar image
leonid18 asked

SSIS error Retrieving the COM class factory

I get this error in SSIS: [Execute SQL Task] Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {32E37890-EC10-4F89-8D74-1B8CAA4C95F2} failed due to the following error: 80040153 Invalid value for registry (Exception from HRESULT: 0x80040153 (REGDB_E_INVALIDVALUE)).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I use SSIS via SSDT (Visual Studio 2015 and 2017). Any suggestions? Does it mean that SSIS got corrupted? And how to fix it, since I am not an expert in Windows registry. OS Windows 10. I get this error when try to run any SSIS package that used to be OK before. I get this error no matter which package or which project. Thanks

ssis error
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·

does your sever have the same SSIS/SSDT version and updates as what you are running locally with visual studio?

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.