Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Error when running Execute SQL Task

Author  Topic 

Kari Suresh Babu
Starting Member

1 Post

Posted - 2010-04-28 : 04:41:36
Hi,

I had migrated DTS 2000 package to SSIS package. I am getting the following error While running the SSIS package:
quote:
[Execute SQL Task] Error: Executing the query "EXEC BIW_SetStatus 'AILA0569971', 'U'" failed with the following error: "[Microsoft][ODBC SQL Server Driver]Invalid cursor state". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Can anybody help me to solve this one.
Regards,

Kari Suresh
   

- Advertisement -