Add an eventSessions at SQL Saturday #136 about SQL Server Integration Services
Your current filters are…
Saturday 14th April 2012
-
Query Tuning Using Lessons Learned from SSIS
by Rob Farley
I'm sure you've noticed the similarities between an execution plan and an SSIS Data Flow Task. Of course there are major differences, such as the fact that you write Data Flow Tasks, whereas execution plans are created based on the T-SQL that you pass to the Query Optimizer and other things such as indexes, statistics and constraints. This talk will consider some of the things that SSIS developers look for when creating an effective Data Flow Task, and show you how those same concerns can be considered when writing queries.
-
New Features of SSIS 2012
by Reza Rad
SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load (ETL) operations. ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart. SSIS 2012 comes with great new features which helps ETL Developers and Architects to create more robust and reliable packages to transfer data. This session will have a brief look at new features in SSIS 2012 and their usages in real-world scenarios.features such as; parameters, data flow changes, project deployment model, development changes, logging, environments, reports and ... will be discusse