SQL Server Integration Services

Got popcorn? Expression Blend 3 SketchFlow and a ton of “GOT TO KNOW ABOUT IT” content is all packed in just 1 hour of Episode 3. Try something different tonight and take an hour break from coding. You know you deserve it. Grab your favorite beverage and pizza and enjoy this…

With the release of the second CTP (Community Tech Preview) of SQL Azure, many developers are starting to get to get to grips with SQL Azure. However, quite a few aren’t aware that many SQL Server features will also work against data stored in the cloud, in SQL Azure. In this video, David…

Have you ever eyeballed your data to find an abnormality? Talk about an instant headache! See Guest speaker MVP Jessica Moss show developer tools are now integrated in Visual Studio as part of the SQL Server Client tools install...among them SQL Server Integration Services (SSIS) Data…

This demo introduces the concept of control flow in a SQL Server 2008 R2 Integration Services package.  Control flow governs the order and precedence of how tasks are executed.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo introduces the concept of data flow in a SQL Server 2008 R2 Integration Services package.  Data flows can be developed to extract data from multiple sources, and then integrate and transform that data into a format that is useful for reporting and analytics.  Presenter: Peter…

ETL processing (extract, transform, load) is a fundamental component of many Microsoft BI solutions.  ETL enables the transformation of raw data into meaningful and actionable information.  SQL Server 2008 R2 Integration Services provides a comprehensive set of tools and services for…

This presentation introduces how SQL Server 2008 R2 Integration Services uses control flow to govern the order and precedence of how tasks are executed. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

SQL Server 2008 R2 Integration Services includes a powerful data flow engine optimized for ETL processing.  This presentation covers how to build data flow tasks which are a fundamental part of any ETL process. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

Dimensional data models have unique traits that must be considered when implementing an ETL process to load them.  This presentation describes how to load fact and dimension tables in a SQL Server 2008 R2 Integration Services package, including slowly changing dimensions.  Presenter:…

SQL Server 2012 Integration Services introduces a host of new improvements of interest to developers and IT Professionals alike.  Developers will appreciate a greatly improved package design experience, and IT Professionals will find a powerful new set of tools and services that will greatly…