Hi All,
Please if someone can give me an idea of how i can come over the error that has been generated by SQL Server 2000 while using DTS.
In my case.i have 2 SQL databases which periodically required to transfer few tables from each other for the application to perform a report there upon.
while transfering objects b/w the database i got below error:
Error at source for row number 2142.Errors encountered so far in this task :1
Page (1:5742) slot:24 for text,ntext or image node does not exist.
I have found the same errors while getting return of the rows from different tables,which seems a corruption of tables??
Any suggestion to over come on this issue would be appreicated..Th anks in Advance.
Adnan
Please if someone can give me an idea of how i can come over the error that has been generated by SQL Server 2000 while using DTS.
In my case.i have 2 SQL databases which periodically required to transfer few tables from each other for the application to perform a report there upon.
while transfering objects b/w the database i got below error:
Error at source for row number 2142.Errors encountered so far in this task :1
Page (1:5742) slot:24 for text,ntext or image node does not exist.
I have found the same errors while getting return of the rows from different tables,which seems a corruption of tables??
Any suggestion to over come on this issue would be appreicated..Th anks in Advance.
Adnan