Great video providing context, overview and demo of SSDT. Taken from Microsoft Ignite New Zealand 2015:
Tags » SSDT
Download SQL Server Data Tools (SSDT) 17.1 for Visual Studio 2015 (SQL Server Integration Services - SSIS - project template)
Possibly save 1 hour of your time: This is a quick reference guide for getting the SSIS project template within Visual Studio 2015.
Download link here 102 more words
In SSDT project, you could create everything you want and keep them identical with target database. However, security might be an exception, few reason you might want to manage security out side of SSDT project: 192 more words
Continuing the section on trying to get a large legacy database imported into an SSDT project that actually builds, we’re at a point now where we should have genuine reference issues to clean up; all our cross database references should be sorted via a database reference to a DACPAC (with or without changing everything to use SQLCMD variables or not). 487 more words
What is SSIS? It stands for SQL Server Integration Services which may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing. 1,143 more words