Build & manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action & dive deep into the SSIS engine SSISDB catalog & security features. Using the developer enhancements in SQL Server 2012 & the flexible SSIS toolset youll handle complex data integration scenarios more efficiently
- & acquire the skills you need to build comprehensive solutions. Discover how to: Use SSIS to extract transform & load data from multiple data sources Apply best practices to optimize package & project configuration & deployment Manage security settings in the SSISDB catalog & control package access Work with SSIS data quality features to profile cleanse & increase reliability Monitor troubleshoot & tune SSIS solutions with advanced features such as detailed views & data taps Load data incrementally to capture an easily consumable stream of insert update & delete activity