?
Solved

Error Loading dbf files into SQL Server 2005

Posted on 2010-01-12
5
Medium Priority
?
589 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:JLEmlet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Chris M
ID: 26300908
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
 

Author Comment

by:JLEmlet
ID: 26442276
I confirmed that we're running SP3 for both client and server.
0
 
LVL 12

Expert Comment

by:Chris M
ID: 26452916
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
 

Author Comment

by:JLEmlet
ID: 26453941
the local results were the same.
0
 

Accepted Solution

by:
JLEmlet earned 0 total points
ID: 26581392
I have worked around this issue by asking for the files to be sent csv rather than dbase.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question