Install a SQL Server 2014 CTP2-enabled SSIS build environment

Page updated :

Visit the following site and download SQL Server Data Tools for SQL Server 2014 CTP2.

SQL Server Data Tools for SQL Server 2014 CTP2 をダウンロード

Run the downloaded "SSDTBI_VS2012_x86_JPN.exe" file. When you do this, it is recommended that you run it in a folder that does not contain Japanese or symbols in the folder path. Otherwise, you may get an error in the file expansion.

SSDTBI_VS2012_x86_JPN.exe を実行

Where to extract the file. If the destination folder path is alphanumeric only, expand it as is. The installer runs automatically after deployment.


When the installer starts, select Run a new stand-alone installation of SQL Server or add functionality to an existing installation.

SQL Server の新規スタンドアロン インストールを実行するか、既存のインストールに機能を追加しますを選択

Read the license terms carefully and if you can agree, check "I accept the license terms" and click Next.


Check SQL Server Data Tools - Buisiness Intelligence for Visual Studio 2012 and click Next.

SQL Server Data Tools の選択

When the installation is complete, click the Close button.


Start SQL Server Data Tools for Visual Studio 2012 from the Start menu.

SQL Server Data Tools for Visual Studio 2012 を起動

You can choose the default environment at any time. Once set, select Start Visual Studio.


When Visual Studio starts, create a project by selecting New - Project from file in the menu.

ファイル - 新規作成 - プロジェクト

Select Business Intelligence from the left menu and Integration Services from the middle menu.

After you have specified the name of the project and the folder where you want to create the project, click the OK button.

Integration Services プロジェクトの作成

The Integration Services project is created.


Since one package has been created, you can place various components there to create a processing flow. You can also add packages as needed to create a flow.

By the way, SQL Server itself is not installed, but you can create the SSIS project itself. You can also exchange data with databases on other servers if they are not local databases.