• SSDT is now the BIDS client tool for working with Business Intelligence projects with SQL Server. You can download SSDT from here that includes support for SQL Server 2014 as well.

    Once you have that installed you can work with the projects from within the SSDT environment, you just would not be able to deploy the projects to an actual SQL Server instance. The services (or components) do not exist with the SQL Server Express Edition. You would just execute your projects from within SSDT. I believe most books or tutorials you work through to get familiar with SSIS task and building of actual packages will work with just SSDT and a database in Express Edition. The only thing lacking would be the deployment process itself. This is the type of environment I generally use for development and general testing of certain things with SSIS or SSRS.

    If you would like to also work on having the projects deployed and run within an environment or instance of SQL Server similar to a real production system then I would suggest purchasing a developer license. The developer edition is same functionality and features of Enterprise Edition. This will provide the components for SSIS, SSRS, and SSAS (the services that execute or run the packages/files). General cost of Developer Edition is about $50 (U.S.).

    EDIT

    One addition, you can actually download SQL Server Express with Advanced Services (download and install this file: ENU\x64\SQLEXPRADV_x64_ENU.exe). This will include the SSRS.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton