Home » SQL ServerRSS

Code: 0xC002F210


Hi All,

Error: 2011-01-25 07:00:58.03
   Code: 0xC002F210
   Source: Update Statistics Task Execute SQL Task
   Description: Executing the query "UPDATE STATISTICS [dbo].[INVESTMENT_TRANSACTION_AL..." failed with the following error: "A severe error occurred on the current command.  The results, if any, should be discarded. A severe error occurred on the current command.  The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

from the above error message, please explain the following:

1) Code: 0xC002F210
2) A severe error occurred on the current command.  The results, if any, should be discarded. A severe error occurred on the current command

Thanks,
Satish Kumar.
 

3 Answers Found

 

Answer 1

Hi Satish,

To answer your questions:

1. 0xC002F210 is DTS_E_SQLTASK_ERROREXECUTINGTHEQUERY (self-explanatory).: http://msdn.microsoft.com/en-us/library/ms345164.aspx

2. Basically, it says to disregard any results or revert changes if any happened because of the error executing query.

You should probably start from posting a query you are trying to execute and options that you have set for your Execute SQL SSIS Task. And, most likely, SQL Server Integration Services forum is a better place to post this (you don't have to post it there again though).

Regards,

Akim

 

 

Answer 2

Hi Akim,

 

This occurs during the update stats...

 

Thanks,

Satish Kumar.

 

Answer 3

Hi Satish,

Can you run the same query in MAnagement Studio?

With all the details provided, here is my best guess:

"Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

You will find something wrong if you check all mentioned above points of failures.

Regards,

Akim

 
 
Search for  Code: 0xC002F210
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter