Missing some components in SSIS toolbox in Visual Studio 2017

sql-server-2016ssistoolboxvisual-studio-2017

I am using Visual Studio Community 2017 for developing SSIS packages and I use SQL Server 2016.

Some of components are not in SSIS Toolbox.

This is that I have now:

enter image description here

and this is my colleges have(They don't have the same version of Visual Studio that I have):

enter image description here

For example: I need to add a XML Source component to one of my Data Flow but there is not anymore in Other Sources sector in SSIS Toolbox.

I tried to add the missing components (Tools -> Choose Toolbox Items ->) but I don't have the tab for SSIS component.
enter image description here

How can I add those components (For example XML Source) to my Toolbox?

Best Answer

I have found the cause of this problem.

By changing the TargetServerVersion to SQL Server 2016 in Project properties. My project has been converted and now i have this component in my ToolBox.

enter image description here

Now, I have XML Source component in my SSIS ToolBox.

enter image description here

Related Topic