Hi Guys,
I am copying data from database to an excel file through SSIS.
database is MS SQL 2005 and BIDS is also 2005
However, the job doing this task fails every time.
As per investigation, the result of the query is more than 100,000 rows
and we know that excel has a limit of 65000 rows of data.
Is there a way of setting the limit up? or something? a better approach maybe so that everything will be copied to the excel file successfully.
Thanks 🙂
By the way, the error is provided below. Thanks.
" The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4. 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. End Error Error: 2015-10-22 04:34:58.05 Code: 0xC0047021 Source: Data Flow Task Description: 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:30:00 AM Finished: 4:35:05 AM Elapsed: 304.844 seconds. The package execution failed. The step failed. "