Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Export Huge Table to Text Files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-08 : 07:39:43
clok writes "Hello,

I have a SQL job that runs regularly to BCP these tables (up to 7 millions records each) to text files in another server.

For some unknown reasons, sometimes these text files are partial/complete and yet there is no error message.

So, I run the BCP in query analyzer and see that sometimes the number of records that get copied are less than that in the table. And I cannot catch any error because there is no error.

Could someone please help?

Thank you so much."
   

- Advertisement -