469,315 Members | 1,583 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

DTS text file export missing records

DF
Hello,

We have a query which returns ~2.8 million rows. This same query is
used in a DTS package, which exports to a text file. The number of
rows in this text file, however, is ~2.7 million rows (I'm rounding of
course.) So a good chunk of data vanished in the export it appears.

Using SQL Server 7.0 on Windows 2000.

Anyone see bugs w/ DTS text exports for very large amounts of data?

Thanks,
DF
"Never eat more than you can lift." Miss Piggy
Jul 20 '05 #1
1 3393
I have used DTS to export bigger tables and never had any problems.

You could try bcp to see how many rows it extracts.

Is there any pattern to the rows that it does not extract, eg ones
near the end, those with a particlar value (perhaps strings containing
a control character)?
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by phatnugs420 | last post: by
reply views Thread by Thomas 'Skip' Hollowell | last post: by
4 posts views Thread by news | last post: by
2 posts views Thread by Pecanfan | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.