Visual Studio 2017 中 SSIS 工具箱中缺少某些组件 [英] Missing some components in SSIS toolbox in Visual Studio 2017
问题描述
我使用 Visual Studio Community 2017
开发 SSIS 包,我使用 SQL Server 2016.
I am using Visual Studio Community 2017
for developing SSIS packages and I use SQL Server 2016.
某些组件不在 SSIS 工具箱中.
Some of components are not in SSIS Toolbox.
这是我现在拥有的:
这是我的大学拥有的(他们没有我拥有的相同版本的 Visual Studio):
and this is my colleges have(They don't have the same version of Visual Studio that I have):
例如:我需要将 XML Source
组件添加到我的 Data Flow
之一,但在 SSIS 工具箱的其他源部分中不再有.
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.
我尝试添加缺少的组件(工具 -> 选择工具箱项目 ->),但我没有 SSIS 组件的选项卡.
I tried to add the missing components (Tools -> Choose Toolbox Items ->) but I don't have the tab for SSIS component.
如何将这些组件(例如 XML Source
)添加到我的工具箱中?
How can I add those components (For example XML Source
) to my Toolbox?
推荐答案
我已经找到了这个问题的原因.
I have found the cause of this problem.
通过在项目属性中将 TargetServerVersion
更改为 SQL Server 2016
.我的项目已经转换,现在我的 ToolBox
中有这个组件.
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
.
现在,我的 SSIS 工具箱中有 XML Source
组件.
Now, I have XML Source
component in my SSIS ToolBox.
这篇关于Visual Studio 2017 中 SSIS 工具箱中缺少某些组件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!