Sessions & Content

Tags
Content Type
Search
Conference
Cleaning Up Dirty Data with SSIS
In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.
ETL shootout-SSIS vs Powershell
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
Scaling Out SSIS With Parallelism
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
SSIS 2012 logging and monitoring
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
<<1>>