SSIS in SQL Server 2008

In this session I want to go through some of the powerful things you can do in SSIS in SQL Server 2008 that will make your ETL requirements simple. We will look at the features you are going to use every day and not "cool but random" ones.  Very interactive.  I want everyone to understand why using SSIS makes sense. 
Presented by Allan Mitchell at SQLBits V
Tags SSIS , ETL
  • Downloads
    Slide deck available Slide Deck 108 KB
    Video available WMV Video 299 MB
  • SpeakerBIO
    allan_mitchell.jpg
    Allan is the joint owner of Copper Blue Consulting Ltd.  I work with companies helping them to decide how best to store their data  Key/Value (Redis) Document (DocumentDB, Mongo) Relational (SQL Server) NoSQL (Hadoop/HBase) I also help customers to decide on whether a move to cloud based offerings makes sense. The Azure platform from Microsoft has a lot to offer and it isn't necessarily a Cloud/On Premise binary choice. Hybrid scenarios make a lot of sense too. I also work with customers who have large scale or interesting data movement requirements. This could be batch processes which are complex or real-time sensor and telemetry data. We offer training as well as consultancy.  www.Copper-Blue.com
    http://www.Copper-Blue.com
  • Video