Attunity RMSCDC for SSIS not showing up in VS 2017 (SSDT)


I’m working on a task to upgrade our SQL Server Environment from 2008R2 to 2017. There are no databases and only SSIS packages that I need to upgrade/migrate. However, the SSIS packages are configured with the third party component (Attunity) which is making the move challenging. I have successfully deployed all components of Attunity from old server to the new one. All components as in the screenshot below installed successfully without any issue:

enter image description here

Problem:

I am currently stuck at this point:

In the old BIDS (2008) when we right click the solution we can see the RMSCDC for SSIS, see screenshot below: enter image description here

This item is missing in the newer SSDT 2017. enter image description here

Question: I have never worked with this third party tool before and I’m currently lost. I wonder if there is a different way to access it?

As per vendor everything should work but did not provide any solution, in other words not very helpful. So I thought posting it here may caught someone else’s attention who may had dealt with this issue.

Also when I try to upgrade the SSIS packages via SSIS Packages Wizard via SSDT I get fury of errors that I can’t even post the whole Report here because of restrictions on number of characters that can be posted in the body.

Here are some errors starting from the top though:

- Upgrading package BranchCDC.dtsx (Error) Messages Information 0x40019316: : The provider name for the connection manager "LOCALHOST.SSISConfig" has been changed from "SQLNCLI10.1" to "SQLNCLI11".  Information 0x40016019: : The package format was migrated from version 3 to version 8. It must be saved to retain migration changes.   Warning 0x40016044: Write Informational Message and Set Group Name: Found SQL Server Integration Services 2008 Script Task "ST_d877e0bbc6ce43d1b268e1f9b7f0a0f4" that requires migration!  Information 0x4001601a: Write Informational Message and Set Group Name: The Script Task "ST_d877e0bbc6ce43d1b268e1f9b7f0a0f4" has been migrated. The package must be saved to retain migration changes.  Information 0x4001601a: Write Informational Message and Set Group Name: The Script Task "ST_d877e0bbc6ce43d1b268e1f9b7f0a0f4" has been migrated. The package must be saved to retain migration changes.  Information 0x4001601a: Write Informational Message and Set Group Name: The Script Task "ST_d877e0bbc6ce43d1b268e1f9b7f0a0f4" has been migrated. The package must be saved to retain migration changes.  Error 0xc001f02a: BranchCDC Loop Container: Cannot create a task from XML for task "Initialize Change Processing Task", type "Attunity.SqlServer.Dts.Tasks.CDCLaunchTask, Attunity.SqlServer.Dts.CDCLaunchTask.RMS10, Version=1.0.0.0, Culture=neutral, PublicKeyToken=fcbb2bf343e73c50" due to error 0xC001F430 "An error occurred while accessing an internal object. This could indicate a custom extension built for Integration Services 2005 is being used.".   Error 0xc0010018: Initialize Change Processing Task: Failed to load task "Initialize Change Processing Task", type "". The contact information for this task is "".   Error 0xc0047067: Load TMPFL_TROUBL_EVT: The "CDC_TROUBL" failed to cache the component metadata object and returned error code 0x80131600.   Error 0xc0000036: Load TMPFL_TROUBL_EVT: Failed to create COM Component Categories Manager due to error 0xC0047067 "The "%1" failed to cache the component metadata object and returned error code 0x%2!8.8X!.".   Error 0xc0048021: Load TMPFL_TROUBL_EVT: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".   Error 0xc004801f: Load TMPFL_TROUBL_EVT: The component metadata for "CDC_TROUBL" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.   Error 0xc0047067: Load TMPFL_NODE_EVTSTG: The "CDC_NODE" failed to cache the component metadata object and returned error code 0x80131600.   Error 0xc0000036: Load TMPFL_NODE_EVTSTG: Failed to create COM Component Categories Manager due to error 0xC0047067 "The "%1" failed to cache the component metadata object and returned error code 0x%2!8.8X!.".   Error 0xc0048021: Load TMPFL_NODE_EVTSTG: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".   Error 0xc004801f: Load TMPFL_NODE_EVTSTG: The component metadata for "CDC_NODE" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.   Error 0xc0047067: Load TMPFL_DESCRP_EVT: The "CDC_DESCRP" failed to cache the component metadata object and returned error code 0x80131600.   Error 0xc0000036: Load TMPFL_DESCRP_EVT: Failed to create COM Component Categories Manager due to error 0xC0047067 "The "%1" failed to cache the component metadata object and returned error code 0x%2!8.8X!.".   Error 0xc0048021: Load TMPFL_DESCRP_EVT: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "". 

Environment info:

old server OS: Windows Server 2008R2 old SQL Server: SQL Server 2008R2 New SQL Server: 2008R2 New SQL Server: 2017 Old Development Tool: BIDS 2008. New Development Tool: VS 2017 with SSDT 2017.  

Any help or guidance would be greatly appreciated.