VS2013 not picking up SQL2012 SSIS Custom Componen

问题:

I am trying to create a custom SSIS component. While I use Visual Studio 2013 premium as my main IDE I seems to have fallen into the below problem.

When I create a SSIS custom component (class library, .Net 4.0 using dlls from 110's x86 folder) I am successfully able to compile, build, register at GAC and copy them to 110's DTS component folder. Now here is the problem. When I create Integration Services Project in VS2013, I cannot see my newly created component in the SSIS toolbox. While if I create ISP project in VS2010 I see my component.

Does anyone know what is going on? I created the component using VS2013, but VS2013 will not show my component in SSIS toolbox...

Bonus question - While playing around i deleted my AppData\Local\Microsoft\Microsoft SQL Server\110\SSIS\SSISToolboxConfig.dat file and now VS2013 shows exception in the ssis toolbox not showing any compoents. while vs2010 runs fine? The file is back now in the folder but problem persists. Exception says - exception while constructing the content of this frame.

回答1:

Wherever you've installed SQL Server, you'll have some number named folders

• 80 SQL Server 2000
• 90 SQL Server 2005
• 100 SQL Server 2008/SQL Server 2008 R2
• 110 SQL Server 2012
• 120 SQL Server 2014

SQL Server file names vs versions

You're using Visual Studio to create an assembly. Period. Full stop. The version of studio you are using has no bearing on whether it's going to work with SSIS.

Instead, what will matter is the assemblies you reference. Unfortunately for those that develop custom tasks and components, they are bound to specific versions of the SQL Server product.

Since you're using the 110 assemblies, you're targeting SSIS for SQL Server 2012 which means SQL Server Data Tools - BI Edition/SSDT-BI for Visual Studio 2010 or Visual Studio 2012.

Visual Studio 2013, once you install SSDT-BI addon will only target SQL Server 2014.

A wise man once commented

I love the VS / SSDT / SQL Server version matrix. It's like a 47-sided Rubik's cube.

回答2:

You did not mention the fact that you need to right click on the components selection window (generally to the left) and pick the new custom component (assuming, you used the right GACUTIL version to deploy the component).