Action:

While using the OLE DB Destination inside of Data Flow Task Plus, the following error is encountered.

Error Message:

“Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies”

Solution:

We have recently seen the issue below with the ADODB module. This is the interop module for connections with the old ADODB technology. Apparently, the most recent SQL Server versions are not deploying the module in the location it previously existed. 

The first solution is to install the latest 2.0 version of COZYROC SSIS+ and above. We have included that module as part of our installation.

The second solution is to search for the module and then manually register the interop module in the Global Assembly Cache (GAC).  

Ideas:

Have you seen how COZYROC’s advanced Data Flow Task Plus replaces the standard Data Flow Task, and allows setup of dynamic data flows? This feature lessens the need to manually open and modify the data flow design when new source and destination columns have to be accommodated.

Data Flow Task Plus also allows exporting of data flow logic and reuse in other packages. Keeping your SSIS data flow logic separate from your package helps you keep track of the changes independently in your source control system. Data Flow Task Plus also provides a customizable user interface for setup of your data flow. You customize the data flow setup dialog by implementing an SSIS script, which is part of the data flow task.

These features will help you be more productive and allow you to componentize your common data flow logic.