I am new to SSIS. I successfully migrated my DTS package into SSIS. In this i have four "Execute SQL Task"s. Three are excuting fine. But one is giving the following error:
"[Microsoft][ODBC SQL Server Driver]Invalid cursor state".
In the task i used
SQLSourceType: Direct Input
SQLStatement: EXEC HX_SetStatus 'HDC0001971', 'U'
And no Parameter Mapping and no Result Set.
Can anybody help me regarding this.