Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with

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.