[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation.".
The SSIS package has failed when the oledb datasource query dynamically building..
Resoution:
ADD this query
SET ANSI_WARNINGS OFF
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation.".
The SSIS package has failed when the oledb datasource query dynamically building..
ADD this query
SET ANSI_WARNINGS OFF
I am receiving the following error, but it was temporaray. A step of the job failed for just 1 day...from next day the job was running fine. The error was:
ReplyDeleteMessage
Executed as user: dc\cmaudsloader. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4321.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:13:56 AM Error: 2015-04-20 08:22:26.19 Code: 0xC0202009 Source: Data Flow Task OLE DB Source [574] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation.". End Error Error: 2015-04-20 08:22:26.19 Code: 0xC0047038 Source: Data Flow Task SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (574) 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:13:56 AM Finished: 9:14:06 AM Elapsed: 3609.43 seconds. The package execution failed. The step failed.