Link to home
Start Free TrialLog in
Avatar of JLEmlet
JLEmlet

asked on

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.
Avatar of Chris M
Chris M
Flag of Uganda image

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.
Avatar of JLEmlet
JLEmlet

ASKER

I confirmed that we're running SP3 for both client and server.
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?
Avatar of JLEmlet

ASKER

the local results were the same.
ASKER CERTIFIED SOLUTION
Avatar of JLEmlet
JLEmlet

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial