I have been trying to run a job using SQL Server Agent and I am receiving the following error below. I have made sure to install all components needed found here: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html.
I have also made sure to set the job to run using 32 bit runtime. The configuration properties for debugging on the package itself is also set to false for Run64BitRuntime. The DelayValidation properties have been set to true on my source as well. Does anyone have any ideas on what this error means and what may be a potential fix? Thanks!!
Code: 0xC0202009 Source: Package Connection manager "Source" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007007E. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.". End Error Error: 2017-11-16 15:10:58.95 Code: 0xC020801C Source: UPDATE FINANCIAL_TRANSACTIONS TABLE - Triton Server FINANCIAL_TRANSACTIONS TABLE - Opera [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Source" failed with error code 0xC0202009. Source: UPDATE FINANCIAL_TRANSACTIONS TABLE - Triton Server SSIS.Pipeline Description: FINANCIAL_TRANSACTIONS TABLE - Opera failed validation and returned error code 0xC020801C. End Error Error: 2017-11-16 15:10:58.95 Code: 0xC004700C Source: UPDATE FINANCIAL_TRANSACTIONS TABLE - Triton Server SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-11-16 15:10:58.95 Code: 0xC0024107 Source: UPDATE FINANCIAL_TRANSACTIONS TABLE - Triton Server Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1).
User contributions licensed under CC BY-SA 3.0