Solved - Retrieving the COM class factory for component with CLSID in SSIS

SQL_icon_base.jpg I get strange error during redeveloping one SSIS. When I tried run some SQL task, finally such an easy one with "SELECT 1", I always received same error.

[Execute SQL Task] Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. 

 

I digg around, check all SSIS properities, SQL task properities, but finally I find solution on socials Microsoft MSDN page

Solution

Run from command line:

RegSvr32 SQLTaskConnections.dll


Add comment

Security code
Refresh

Twitter