4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Automating SSIS

I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward.
The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into.

After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc.

This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)

Presented by Andre Kamman at SQLBits VII
Tags SSIS , DBA
  • Downloads
  • SpeakerBIO
    Andre_Kamman.jpg
    André is a freelance SQL Server specialist. He has done a lot of DBA work on 100’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW. 
    André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland
    http://andrekamman.com http://andrekamman.com/feed
  • Video