SSDT uses a subset of the full version of Visual Studio 2013. It is where you create and deploy your SSIS projects.
The SQL Server Data Tools (SSDT) is where you’ll spend most of your time as an SSIS developer. Working with SQL Server 2014 Change Data Capture In SSIS.SSIS Workflow Tasks – Integration Services.Windows Management Instrumentation Tasks In SSIS.Versioning and Source Code Control - SSIS.Various Types of Transformations In SSIS - 2014.Understanding Data Types Using Variables, Parameters and Expressions - SSIS.Typical Mainframe ETL With Data Scrubbing In SSIS.SQL Server The Data Flow Sources in SSIS 2014.SQL Server Management Objects Administration Tasks In SSIS.SSIS Script Task Assign Value to Variable.Pipeline Performance Monitoring In SSIS.What is Open Database Connectivity (ODBC) in SSIS.Import and Export Wizard in SSIS with SQL Server Data.Using the Merge Join Transformation in SSIS.Overview of Master Data Services SQL Server in SSIS.Software Development Life Cycle in SSIS.
#SQL SERVER DATA TOOLS FOR SQL SERVER 2014 DOWNLOAD HOW TO#
Data Profiling Task in SSIS with Example.Learn Cache Connection Manager and Cache Transform in SSIS.Bulk Insert Task in SSIS Package - SSIS.SSIS – Analysis Services Processing Task, Execute DDL Task.Fuzzy Lookup and Fuzzy Grouping in SSIS.Administering SSIS Using The SSIS Catalog.Guide for Accessing a Heterogeneous Data In SSIS.