Hi.

I have a DTS package that selects rows from one SQL table and inserts them
into another SQL table. I received the following error message after
processing 3 million rows Iinput SQL table bas 5 million rows):
"Could not complete cursor operation because the table schema changed after
the cursor was declared".

Any suggestions will be greatly appreciated. I'm thinking it's a volume
issue but was able to import the 5 milllion rows originally from a text file
into the first SQL table via a DTS package.

Rita

While the cursor was running did any one make changes to the table
structure? If so this is your issue.

Rick

"RitaG" <RitaG (AT) discussions (DOT) microsoft.com> wrote

Hi Rick,

Thanks for the response. No changes were made to the structure. The DTS
package was changed to start from the row where it failed and it went through
ok.
We'll probably reboot the machine it was running on and try again.

Rita

"Rick Gittins" wrote: