SSIS Package fails when importing DBase 5.0 File.

Question

SSIS Package fails when importing DBase 5.0 File.

Joe Jackson-450611

SSC-Addicted

Points: 402
More actions
May 5, 2009 at 11:10 am

#130531

Hi, trying to import dbase file into sql server 2005 using ssis package. I setup Native OLE DB \ Jet 4.0 OLE DB Provider as my import source and followed some help that I found to setup as dbase 5.0 and seems to work and previews data fine. When I try to import into sql table, I get the following errors. I tried just going to text file as output and same thing. I've seen simliar errors but usually gives a field name or some hint as to what it might be. Any ideas?
--------------------------------------------------
Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (7380) 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: 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: 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: 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.
--------------------------------------------
Thanks,
Joe

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

Joe Jackson (5/5/2009)
Hi, trying to import dbase file into sql server 2005 using ssis package. I setup Native OLE DB \ Jet 4.0 OLE DB Provider as my import source and followed some help that I found to setup as dbase 5.0 and seems to work and previews data fine. When I try to import into sql table, I get the following errors. I tried just going to text file as output and same thing. I've seen simliar errors but usually gives a field name or some hint as to what it might be. Any ideas?
--------------------------------------------------
Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (7380) 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: 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: 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: 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.
--------------------------------------------
Thanks,
Joe

Does the machine where you execute your SSIS package running under 64bit OS ?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Joe Jackson-450611 SSC-Addicted Points: 402 More actions · Answer 2

No, 32 bit windows 2003 server sp2 and sql 2005 sp3. Thanks, Joe

samalex SSCertifiable Points: 5429 More actions · Answer 3

Joe,

I had a similar problem with importing in dBase files into MS SQL through SSIS, and my work around was to create an Access Database with Linked Tables linked to the dBase files. Then in SSIS I just setup the Access database as an OLE DB source and was able to pull the data in that way.

Worked like a champ... maybe not ideal but saved me lots of headache 🙂

Sam Alex

Joe Jackson-450611 SSC-Addicted Points: 402 More actions · Answer 4

I tried linking access to dbase file and displays fine in access db but when I setup source in ssis package, it doesn't show that table. It shows other access tables but not the linked table. It looks like not allowing to select any linked tables because it doesn't show linked sql tables either. Too bad because that sounds like it would do the job unless I am doing something wrong?

If not, I found a free dbf to csv converter that can run from command line so I think I can add a ssis process task to run this converter then import the csv file to sql.

Thanks,

Joe