Hi
I have a DTS package that exports the contents of a table to a text file over the network. The table has about 100,000 records. when run it exports the first, say, 17,000 records and the rest gives errors.. before it gives an error message at a specific row number. The data in the source table is perfect, but something happens in the transaformation. We are running SQL 2000

cheer

And the errors are?

--
--

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


"Barnabie" <nuve.nai (AT) middlemore (DOT) co.nz> wrote

the first, say, 17,000 records and the rest gives errors.. before it gives
an error message at a specific row number. The data in the source table is
perfect, but something happens in the transaformation. We are running SQL
2000.