Why do I get the following error when executing a package under Business Intelligence Development Studio (BIDS)?
System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
We have seen this error when using Oracle Data Provider for .NET 11.1.0.6.20 on 64bit OS. By default the SSIS project is setup to use the 64bit SSIS runtime for package debugging purposes. Set Run64BitRuntime project property to False to force SSIS to execute with the 32bit runtime.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How do I start using COZYROC SSIS+ in Business Intelligence Development Studio (BIDS) or Visual Studio?
As of the 2012 version of Visual Studio, there is no need to import the extensions for SSIS+. When you run the COZYROC installer package file, the extensions are imported and the COZYROC SSIS+ components and tasks will show up in the SSIS Toolbox. If ...Why do I get the following error when executing a package under SQL Server Agent Job or DTEXEC?
System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. We have seen this error ...Why do I get the following error during data flow execution?
Invalid parameter binding Parameter name: ... An input data flow column type doesn't match output Oracle column type. Use the standard Data Conversion Transformation to setup the proper column type.Where can I find the documentation for the Oracle Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Oracle Destination can be found at the following link. For many of the components you can find ...Where can I find the documentation for the Database Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Database Destination can be found at the following link. For many of the components you can find ...