Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

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.
0
JLEmlet
Asked:
JLEmlet
  • 3
  • 2
1 Solution
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now