469,128 Members | 1,634 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Error while using DTS package

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..Thanks in Advance.

Sep 16 '07 #1
0 701

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Tony Wright | last post: by
7 posts views Thread by p | last post: by
7 posts views Thread by Norman Diamond | last post: by
3 posts views Thread by =?Utf-8?B?VmFuZXNzYQ==?= | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.