March 3, 2010 at 12:33 pm
I'm migrating my DB and agent over to another machine. Everything works fine except for 1 Data flow task that keeps failing. The Data Reader Source keeps failing with the error details:
[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_THREADCANCELLED. Thread "WorkThread1" 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.
The actual query being run is:
SELECT A.PO_NUM, A.VEND, A.CREAT_DATE, B.INV_ITEM, B.PUR_PRICE_NET_OF_DISC
FROM V_PO_HDR A INNER JOIN V_PO_DTL B
ON A.PO_NUM = B.PO_NUM
WHERE B.INV_ITEM IS NOT NULL
The DataReader Source uses to an ADO.Net connection manager pointing to a Unidata ODBC Connection.
There is nothing wrong with the ODBC connection because there are a other Data Flow Tasks that run queries on it and work fine. Its just this one thats giving me a problem.
Strangely, I can run this whole agent on another machine and it works fine. I don't understand what's wrong..
April 6, 2010 at 1:07 pm
Me gustaría saber si encontraste la causa de este error?
a mi me esta sucediendo lo mismo con un proceso que habia funcionado bien durante varios meses, y de un momento a otro me esta generando este error.
Gracias
April 12, 2010 at 12:06 am
Why not use OLEDB for UniData connection?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply