| Solved - Retrieving the COM class factory for component with CLSID in SSIS |
|
|
| Written by Stanislav Duben | |
| Friday, 15 January 2010 | |
|
[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 Tag it:     |
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.
| Next > |
|---|