Error Loading dbf files into SQL Server 2005

We're trying to load some dbf files into a sql server database.  I get this error when I run the load:

SSIS package "LoadSA.dtsx" starting.
Information: 0x4004300A at finrec, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at finrec, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at finrec, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at finrec, DTS.Pipeline: Execute phase is beginning.
Error: 0xC0047038 at finrec: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "OLE DB Source" (1) returned error code 0x80040E21.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at finrec: SSIS Error Code DTS_E_THREADFAILED.  Thread "SourceThread0" has exited with error code 0xC0047038.  There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047039 at finrec: SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled.
Error: 0xC0047021 at finrec: SSIS Error Code DTS_E_THREADFAILED.  Thread "WorkThread0" has exited with error code 0xC0047039.  There may be error messages posted before this with more information on why the thread has exited.
Information: 0x40043008 at finrec, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at finrec, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at finrec, DTS.Pipeline: "component "OLE DB Destination" (55)" wrote 9886 rows.
Task failed: finrec
SSIS package "LoadSA.dtsx" finished: Success.
JLEmletAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris MConsulting - Technology ServicesCommented:
If you're not running service pack 3 on SQL server, then please update it as soon as possible and try again.

Also ensure that the set of client tools you're using to write the SSIS package is also updated to service pack 3.
0
JLEmletAuthor Commented:
I confirmed that we're running SP3 for both client and server.
0
Chris MConsulting - Technology ServicesCommented:
For some reason, the import operation seems to be terminating before it completes the work.
Could you try using a different server and instance to perform this importation preferably locally and let me know how it goes?
0
JLEmletAuthor Commented:
the local results were the same.
0
JLEmletAuthor Commented:
I have worked around this issue by asking for the files to be sent csv rather than dbase.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.