Install the SQL Server 2014 CTP2 version of the SSIS build

Page creation date :

Go to 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 doing so, it is recommended to run it in a folder that does not contain Japanese or symbols in the folder path. Otherwise, you may get an error in extracting the file.

SSDTBI_VS2012_x86_JPN.exe を実行

Specifies where to extract the files. If the folder path of the destination is alphanumeric only, expand it as it is. The installer runs automatically after deployment.

ファイルの展開

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

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

Read the license terms carefully, and if you agree with them, 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 any of the default environments. Once set, select Start Visual Studio.

既定の環境の選択

When Visual Studio starts, create a project by choosing New > Project from File in the menu.

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

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

After specifying a name for the project and the folder in which 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 on it and create a processing flow. Also, add packages as needed and create a flow.

By the way, SQL Server itself is not installed, but you can create SSIS projects themselves. It is also possible to exchange data with databases on other servers if it is not a local database.

フローの作成