Developing SSIS Packages in SQL Server 2014

  • Hi,

    Installed SQL Server 2014 and was looking BIDS (Business Intelligence Development Studio) with no success. After poking around different forums I gather it is no longer included as part of the standard install and the I need to do the following :

    1 - Install Visual Studio 2013 Express Edition

    2 - Install SSDT-BI for VS 2013

    This would allow me to develop SSIS packages for SQL Server 2014.

    A. Just wanted to check if this was the case and if there any issues installing the above on the same machine as SQL Server 2014 ?

    B. Why has MS decided to go down this route, surely it makes sense to include it as part of the standard SQL Server Install ?

    Thanks in advance.

  • Quick note, the SQL Server Data Tools is the replacement for BIDS and provided as a separate downlod.

    😎

  • And the answer to (A) is that there will be no issues installing it on the same server.

    Though if it's a production SQL server, you would normally not install a client development tool such as VS on it.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply