Making more of SSIS in 2008

Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is a 400 session so you we will hit the ground running and not stop throughout.
Presented by Allan Mitchell at SQLBits II
Tags SSIS , SSAS , ETL
  • Downloads
    Slide deck available Slide Deck 106 KB
  • 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
    The video is not available to view online.