Links from the SSIS Roadmap Session

Here are some of the resources I mentioned in the SSIS Roadmap session at the PASS Summit.

SSIS Reporting Pack from Jamie Thomson

image

 

DQS Matching Transform from OH22 Data

image

 

DQS Domain Value Import Destination from OH22 Data

image

There is also a great series of blog posts (part 1, part 2, part 3) on using these transforms on the DQS team blog.

Data Feed Publishing Components

image

SQL Server Data Tools – Business Intelligence downloads

(update 2014/11/14: added link to the VS 2013 release which came out in April)

Looking for the SSIS development tools? Formerly known as Business Intelligence Developer Studio (BIDS), the designer is now called SQL Server Data Tools – Business Intelligence (SSDT-BI) (not to be confused with the other SQL Server Data Tools). The version you want will depend on two things; your version of SQL Server, and the version of Visual Studio you want to work with.

SQL Server 2012

SQL Server 2014

image

 

Some notes:

  • The SQL Server 2014 CTP2 version of SSDT-BI should not be installed on the same machine as SSDT-BI for SQL Server 2012
  • There is no SQL Server 2014 SSDT-BI for Visual Studio 2010, however, SSIS packages developed in SQL Server 2012 can be automatically upgraded to SQL Server 2014