471,854 Members | 1,983 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,854 software developers and data experts.

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 3447
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
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.