Downgrading CData SSIS edition drivers


Userlevel 3
Badge

Customers may have issues with preexisting connection managers for their packages if they downgrade without performing the proper steps. This fix should theoretically apply to non-CData drivers as well. 

Common issues include: A newly added connection manager would be the same version as the uninstalled driver, A pre-existing connection manager returns something like “…is not recognized as a valid connection manager type”. 

Notes for downgrades: Before completing any downgrade, make sure you backup your SSIS Package / the installers for the used SSIS Components so that you can continue working on another machine in case you make a mistake. We DO NOT advise users to downgrade without properly documenting everything they are doing for that downgrade. 

STEPS: 

1. Uninstall the current version of the SSIS driver you have. 

- Windows: Add/Remove Programs 

OR 

- Navigate to the driver installation directory (“C:\Program Files\CData” by default) and run the “Uninstall” application from the driver’s folder. 

2. Install the version of the SSIS driver you want. 

3. (Optional if still having issues) **Caution: improper configuration here can lead to major issues** 

Manually add the DLL we provide in the driver’s ‘lib’ folder to “<< Microsoft SQLServer Installation Folder >>\xxx\DTS\ PipelineComponents” and the Windows GAC “C:\Windows\Microsoft.NET\assembly\GAC_MSIL”. 

 

 

Please read this for more info before doing step 3: https://stackoverflow.com/questions/47268587/for-a-custom-ssis-component-why-do-i-have-to-put-it-into-gac


This topic has been closed for comments