mssql2k5 db2 to mssql errors

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
I try get data from DB2 (AIX) to MSSQL2k5 using SSIS packages and odbc from
windows client .
All was working correctly until i tried download data with some
transactions. After execute i got errors:
....
[DataReader Source [1]] Error: The component "DataReader Source" (1) was
unable to process the data.
Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on
component "DataReader Source" (1) returned error code 0xC02090F5. 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.
....
[DTS.Pipeline] Information: "component "SQL Server Destination" (399)" wrote
30940 rows.

First 4 columns from table was working OK but when tried 5 first columns
or just 5'th column download the error was the same.
Fatal column source is smallint. I tried convert to int, to char and
problems not solved.

MSSQL have SP3, machine are not x64
I have not idea what i can do to solve problems.

best regards
aja


.

Relevant Pages

  • Re: Component Registration Failure
    ... Error code 15100> ... Execute the command regsvr32.exe atl.dll ... The message was checked by ESET Smart Security. ...
    (microsoft.public.windows.mediacenter)
  • Re: Component Registration Failure
    ... Error code 15100> ... Execute the command regsvr32.exe atl.dll ... The message was checked by ESET Smart Security. ...
    (microsoft.public.windows.mediacenter)
  • Re: All updates = 0kb size, unable to update, WindowsUpdate.log includ
    ... The error code means Handle not valid which suggests to me that ... > Here's the log file after the shutdown and reboot: ... > cookie. ... > CClientCallRecorder::BeginFindUpdates from AutomaticUpdates with call id ...
    (microsoft.public.windowsupdate)
  • Re: make buildworld
    ... > I face w/ problem when i execute make buildworld after ... An erorr message would be helpful. ... Please take note that "Error code 1", ...
    (freebsd-stable)
  • IBM as400 - SQL Server 2005 Beta 2
    ... component returned a failure code when the pipeline engine called ... The meaning of the failure code is defined by the component, ... exited with error code 0xC0047038. ... shutdown, or an error in another thread is causing the pipeline to shutdown.]] ...
    (microsoft.public.sqlserver.dts)