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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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