SSIS Data Flow Items and SSIS Contol Flow Items Tab missing in Visual Studio 2013 from _Choose Toolbox Items_

visual-studio ssis business-intelligence
g.pickardou picture g.pickardou · Oct 28, 2014 · Viewed 11.8k times · Source

I have a VS 2013 installed, and successfully installed "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013"

All BI project templates are OK, all toolbox items are OK. I also can create a new Integration Services project, and toolbox correctly shows all the SSIS out of the box items.

.

All OK, BI seems to installed

.

However when I try to add a new custom Toolbox item and choose Tools/Choose Toolbox Items the dialog has no "SSIS Data Flow Items" and "SSIS Contol Flow Items" tabs.

.

Tabs are missing

.

Because of the tabs are missing, I can not add custom component to my SSIS Data Flow Items tab. The following picture is from a tutorial, it shows what I am expecting to see:

enter image description here

I consider the missing tabs a symptom of something went wrong, but not insist to see the tabs, if there is any alternative way to add custom component to the SSIS Data Flow toolbox. But the most relaxing would be if the tabs were appeared...

Btw I have two machine with this exactly same symptoms, a 2012 Server and a Win 7 box.

Any help appreciated, thanks in advance.

Answer

billinkc picture billinkc · Oct 28, 2014

One of the complaints custom component developers for SSIS had was that installation of their product (to the GAC and Program Files) still required the manual adding of them, as your final screenshot depicts.

2012+ no longer has this requirement. Instead, by virtue of a DLL being correctly built for that specific version of SSIS, "it will just show up" TM

I'm not finding the blog references but there were announcements about the change

"It just works" was already claimed

Related questions

How do I integrate TFS Source Control with Business Intelligence Studio?

I am running Visual Studio 2010 Ultimate -- which integrates with TFS source control. However, when I run SQL Server 2008 Business Inteligence Studio, no source control is offered. When I look under Tools... Options... Source Control... there are no plug-ins available. …

Read More
SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More
Disabling SSIS Package Validation when Loading a Package in the VS Designer

I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the packages, the designer always validates …

Read More