SSIS Package Failure - Module/Component Not found Errors

0

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).  
sql-server
oracle
ssis
package
asked on Stack Overflow Nov 17, 2017 by BuffaloBill • edited Nov 17, 2017 by BuffaloBill

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0