Microsoft SQL Server 2012 Integration Services

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexibl [...]
Visa längre beskrivning

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