This case is from my customer problem about SSIS package during execute by SQL Server Agent as the error message on below : ETLErrorMessageFromAgentLog.txt Error: 2010-12-08 04:11:19.02 Code: 0xC0047022 Source: DFT FactAROutDailyHandy Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SRT REF_DOC_NO" (16580) failed with error code 0x80004005. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2010-12-08 04:11:19.10 Code: 0xC0047021 Source: DFT FactAROutDailyHandy Description: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0x80004005. There may be error messages posted before this with more information on why the thread has exited. End Error I had find the solution from http://msdn.microsoft.com/en-us/library/ms345164.aspx and cannot find any solution that can solve this problem. This case It's can solve by rerun package but it's like non sense to do that. For this package it's take 2-3 hours for rerun. ,,, Any Idea for solve this!!! For more details of the error message, Pls ask Thank you in advance for your kindly support. :)

Could you tell us at which transformation does ur data flow task stop with the error. What are the transformations that you are using? Tweet me..

http://uppic.net/full/34e14b9a63edfbcb03842c3777bd1775 Task is stop at "SRT REF_DOC_NO"

please explain your DFT functionality, what you are trying to achieve and what components you have used inside the DFT?? Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

please explain your DFT functionality, what you are trying to achieve and what components you have used inside the DFT?? Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Some time back I had seen similar issue in this forum and there was nothing done incorrectly there. Could you provide the screenshots of the sort transform as well. Also you could try to delete the sort transform and create a new one and let us know. ETL: Photchani has provided the link to check out his DFT. Tweet me..

In this case I've already found the problem. It's come from one of source is cannot update into table because of it's a NULL value, but it cannot be NULL. I found that after I use profiler detect it. But in another cases in this error message(code : -1073450975) it show : Code: 0xC0047012 Source: Staging OUTSTANDING - AR check TH DTS.Pipeline Description: A buffer failed while allocating 7339984 bytes. >> This task it contains load data from 3 sources -> transformation -> sort -> merge -> insert/update into 1 destination Why the error message it have same code? and any suggest for adjust buffer (I think it have relation between DefaultBufferMaxRows and DefaultBufferMaxSize ,right?)

Sort transformation consumes more buffer... so I would like to suggest you to merge your SORT and Data Conversion task inside the OLEDB source query. In source query you can convert your data type as well as sort it. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi Photchani, From the screenshop you posted, the error happened on a task SORT, and based on your last reply, there is a buffer failed, so the issue might be caused by the buffer usage. In SQL Server Integration Services(SSIS), the SORT task is a Blocking transformations. When a blocking transformation is encountered in the data flow, a new buffer is created for its output and a new thread is introduced into the data flow. This means we need more memory to process the sort. If there is no enough available memory in the server, the processing may fail. In order to solve the issue, we can try to sort the output the source using SQL Command. For more information about Performance Tuning in SSIS, please see: http://technet.microsoft.com/en-us/library/cc966529.aspx If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT