SQL Server Data Tools, released with SQL Server 2012 and coming with Visual Studio 11 Beta, are interesting and certainly worth a look soon, but I decided to first check out something a little simpler ...

Promising that developers can 'save weeks of development effort,' Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.

Select File > New > Project from the File menu in Visual Studio. Click Integration Services under Business Intelligence under the Installed Templates area in the New Project window.

Select File > New > Project from the File menu in Visual Studio. Click Integration Services under Business Intelligence under the Installed Templates area in the New Project window.