Why, when I export table with 100,000 rows is it limited to 6993 rows?
There is nothing in my SELECT or if using the Wizard to limit the rows
output. This happens with all drivers SQL Server OLE DB, or ODBC, text
file, Oracle OLE DB.

I want to export data to Oracle, everything is limited to 6993. No problem
making the connection to Oracle.

SQL Server 2000 sp3

You are exporting from SQL Server ?
You have no restrictive caluses on the statement ?
There are definitley 10,000 rows in the table
Which driver are you using?

On initial inspection it would seem to be Odd and 6993 is hardly a number that would offer clues.


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org