Hi all,

I have a DTS package that should load data from DBF file (saved on local
disk) into empty table on local SQL server. DBF file has about 8 million
records, it loads first 6200000 then it failed with error "Data for source
column xx (XXXX) is not available".

The size of DBF file is about 2.2G, SQL database is on same drive as DBF
file and there is a plenty of free disk space (more than 120G), so this is
not a disk space issue.

There is nothing in SQL log or Event log either.

HEEEELP!

In message <96B5E40C-A4BD-46AB-85DB-8C102179A0C6 (AT) microsoft (DOT) com>, Marin
<Marin (AT) discussions (DOT) microsoft.com> writes
Since you mention disk space, have you check all disks in the machine
that is executing the package. In particular look at the drive where the
temporary folder is situated as some processes require temp files and
can get quite large.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thank you Darren,

The disk space is not an issue in this case, there is a plenty of free disk
space, over 10G on each drive and over 50G free on drive with tempdb.

Marin

"Darren Green" wrote:

I was having the same exact problem, here's how I am fixing it...

The fields I was getting errors on were of typer Numeric and had 10 and 6 as
precision and scale (called something else in VFP). You have to change these
to float and I made the p and s larger (16 and 8) just to be sure. You
cannot just transform this during the dts process, it must be done by
actually modifying the table structure within FoxPro itself. It's a pain in
the butt, but that was how I fixed it. So, hopefully you are using some
weird numerical field in FoxPro and SQL is just finding a goofy record and
not liking it. I too had it go throug like 1/2 a million records before it
encountered the error. None of this easy row 1 stuff. So there you go, hope
this helps.