george sibbald (7/19/2013)
renamed to SSDTBI to avoid confusion! could have fooled me.So with SQL2012 and 2014 install media we dont get the option to install the BIDS equivalent? that sounds a backward step. Or have I misunderstood?
Are SSDT and SSDTBI separate things? which one do I install for developing SSIS packages?
:unsure:
No no, only with the SQL 2014 CTP1 install media there's no option to install a business intelligence development environment. I believe this is because it's just a CTP, used for testing purposes. This issue will probably dissapear in future releases.
When installing SQL Server 2012, you install SSDT, which is essentially BIDS in Visual Studio 2010. SSDTBI is essentially BIDS in Visual Studio 2012.
When developing SSIS packages for SQL Server 2012, you can install SSDT (VS 2010) during the set-up, or you can download SSDTBI (VS 2012) as a seperate tool. Both products can develop SSIS packages for SQL Server 2012. The only difference is that in SSDTBI you have to look at the ugly Visual Studio 2012 interface.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP