ERROR MESAGGE:
“Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with CLSID {…} 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.”
EXPLANATION:
You may experience this error when you want to export data with the Export Wizard. The reason is that SQL Server Agent Service is not running.
SOLUTION:
Make sure that the SQL Server Agent Service is running before using the Export \ Import Wizard.
You can use SQL Server Configuration Manager or Services.msc.
