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:
and this is my colleges have(They don't have the same version of Visual Studio that I have):
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.
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
toSQL Server 2016
in Project properties. My project has been converted and now i have this component in myToolBox
.Now, I have
XML Source
component in my SSIS ToolBox.