I am working with some financial data that has many, many observations, but
failrly small records. I an creating a comma separated variable (CSV) file
using a VB.NET program and then I use DTS Import to import the CSV file into
SQL Server 2000 via a file DSN.

This all works fine for the smaller data sets, but larger datasets with 24
million or 37 million records do not import properly. The DTS import runs,
but it stops, with no error messages, after about 18 million records.

Is there something I can do to track down this problem or is there a
workaround? The system is running on a fully patched Windows 2003 server
system and SQL is fully patched

Thanks,

Bill Patterson
UW-Madison School of Business

Why are you using a File DSN?

Why not use the File (Source) adapter in DTS itself?

Could it be that the connection is getting lost?
Your log blowing?
How are you loading? I would use the ExecuteSQL task if using DTS.

If this is the only thing for which you want to use DTS then consider the
BULK INSERT TSQL statement



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"William Patterson" <wpatterson (AT) bus (DOT) wisc.edu> wrote

I should add that I am using the File (source) adapter in DTS, not a file
DSN.


"William Patterson" <wpatterson (AT) bus (DOT) wisc.edu> wrote

Are you using Transformation Task?
If so, you may want to check on "Always Commit the Final Batch" and then
llok at the next record to see what's wrong
Ed

"William Patterson" wrote: