Hello All I'm using the provider: "Native OLE DB\Unify SQLBase OLE DB Provider" to connect to our source system, using SSIS 2005. I have one connection, one data flow task, with a destination of a blank text file. I can pull through all columns from the particular table, aside from INC_TIME which is in the format at source: HH:MM:SS Everything pulls through fine, apart from this column, where I see the following errors: Error: 0xC0202009 at Not working, IncidentSource [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80020005. An OLE DB record is available. Source: "OLE DB" Hresult: 0x80020005 Description: "Type mismatch.". Error: 0xC0047038 at Not working: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "IncidentSource" (1) returned error code 0xC0202009. 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 Not working: 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 Not working: 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 Not working: 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 Not working, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DD at Not working, TextDestination [238]: The processing of file "C:\Documents and Settings\eis\Desktop\test.txt" has ended. Information: 0x40043009 at Not working, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at Not working, DTS.Pipeline: "component "TextDestination" (238)" wrote 0 rows. Task failed: Not working I'm not running any conversions, or trying to insert it to a SQL table - so I can't understand why it gives errors. Is it somethig to do with the driver? I've tried creating a ne wpackage from scratch, and re-creating the connection, only attempting to extract INC_TIME and I'm getting nowhere. Hope this makes sense, Cheers Leeroyster

what is data type of this column in source database?http://www.rad.pasfu.com

[Time] Cheers

and what is your source database? oracle? mysql ?...?http://www.rad.pasfu.com

There may be some blank spaces in the input data... so first convert your data to DT_DBTIME format or trim your data. apart from this, redirect the error rows to some file and check the data. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

I'm not sure on the specifics of the source database at the moment - wil try to find out... ETL - I've tried your suggestion, and still the process doesn't even get to the data flow stage - it errors out the same. I'm also getting these warnings - however we get these on everything in this system and have never had a problem: Warning: 0x80202066 at Data Flow Task, OLE DB Source [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

I'm not sure on the specifics of the source database at the moment - wil try to find out... ETL - I've tried your suggestion, and still the process doesn't even get to the data flow stage - it errors out the same. I'm also getting these warnings - however we get these on everything in this system and have never had a problem: Warning: 0x80202066 at Data Flow Task, OLE DB Source [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. Its just warning.... delete the current OLEDB source and use the new one again.. let us know your observation.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/