Error Message: "Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies”
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.
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: Could not load file or assembly ADODB
Action: When executing an SSIS package with a COZYROC Task and/or component, the following error is encountered. Error Message: "Could not load file or assembly 'ADODB'..." Recently, customers have reported an issue with the ADODB module, which is ...Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer.
Action: Attempting to open an SSIS package in Visual Studio you might get, under certain circumstances, the error below: Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this ...Data Flow Task Plus editor doesn't open
Action: When I click twice on Data Flow Task Plus Component I get the following error: Error: Data Flow Task Plus' Editor doesn't open and instead of the I get the control flow tab. Solution: To solve the issue you should complete the steps below: ...DataFlowSetting .NET attribute used with Data Flow Task Plus
The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...Error Message: The Flat File Source.Outputs[Flat File Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.
Action: When executing a package using Data Flow Task Plus within a Foreach Loop and a Flat File Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop. Error Message: ''The Flat ...