While creating a new CRM destination, the following error is encountered.
TITLE: Microsoft Visual Studio
The component could not be added to the Data Flow task. Verify that this component is properly installed. Component information:
Name: 'Dynamics CRM Destination'
Description: 'Populates Dynamics CRM destination entity.'
Class ID: 'CozyRoc.SqlServer.SSIS.CrmDestination, CozyRoc.SSISPlus.2017, Version=220.127.116.11, Culture=neutral, PublicKeyToken=16cf490bb80c34ea'
File Name: 'CozyRoc.SSISPlus.2017'
File Version: '18.104.22.168' .
Could not initialize component for use in the designer.
Please verify that this component is properly installed.
Object reference not set to an instance of an object. (CozyRoc.SSISPlus.UI.2017)
SSIS+ 1.8 in Visual Studio 2017 is not supported in SSDT 15.8.1 or later (i.e. SSDT with SQL Server 2019 support)
You are likely using SSIS+ 1.8 and a higher version of SSDT than 15.8.0 (14.0.16174.0) which would cause an incompatibility issue.
You would need to uninstall SSIS+ 1.8, uninstall the current SSDT, install SSDT 15.8.0 (14.0.16174.0) and reinstall SSIS+ 1.8.
Or, you could uninstall SSIS+ 1.8 and install SSIS+ 1.9.
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.