SSIS Balanced Data Distributor 2014 SP1 for VS 2012 doesn't work

0
votes

I'm trying to install SSIS Balanced Data Distributor 2014 SP1 for Visual Studio 2012, but this component is not displayed in the SSIS Toolbox.

I install x86 version of this component. The TxBDD.dll is located in the directory correctly: C:\Program Files\Microsoft SQL Server\120\DTS\PipelineComponents

Also I put the TxBDD.dll to the directory: C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents

How can I fix it?

1
sql-servervisual-studio-2012ssissql-server-2014
Also I put the TxBDD.dll to the directory: C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents – Sergey

1 Answers

2
votes
  • SQL Server 2014 -> Visual Studio 2013
  • SQL Server 2012 -> Visual Studio 2012

You have downloaded a component for the designer associated to VS 2013 and expect it to work in 2012. That's not a feature of the designer at this point.

The resolution is to get the 2013 SQL Server Data Tools-BI edition installed. That will allow you to use the BDD component (and nothing else will)