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…

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution.  This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1…

In this episode, Kirk Evans talks with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company.  Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US.  We…

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…

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…

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…

In this geekSpeak, Microsoft Most Valuable Professional (MVP) Andy Leonard discusses best practices for using Microsoft SQL Server Integration Services (SSIS) in the enterprise. Andy explains what SSIS does well and doesn't do well and describes common struggles when learning SSIS (expressions,…

This demonstration explores the new features of SQL Server 2012 Integration Services (SSIS). Specifically it covers project conversion, parameters, project connection managers, deployment to the SSIS catalog, package execution and viewing the built-in reports. Peter Myers Mentor, SolidQ

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…

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:…