Error In DTS – sql task execution. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error In DTS – sql task execution.

Error Source : Microsoft OLE DB Provider for SQL Server Error Description : Could not complete cursor operation because the table schema changed after the cursor was declared. —–> This is the error i received when i executed the SQL task from dts designer. But the execution is happened properly and completed till the end of program. I wonder now with this message.. What is the problem.. Kindly someone help me. Abdul Lateef.
Polaris Software Labs.
001 91 44 4341964.
You may try using the profiler on your database to see what queries are executing at the time you receive the error, this was how I was able to find the problem. Also make sure no other process accessing the same table process. HTH Satya SKJ