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
    elastIO focusses on search and data integration. Text data is increasing at an incredible rate.  Being able to derive meaning and intelligence from free text is hard but necessary if businesses are to get any ROI from things such as weblogs.  Search can offer your users a much better experience over your websites enabling them to find the things they need quicker. We have extensive experience in elasticSearch, SolR and Azure Search. Data will always need to flow from one place to another.  This could be the overnight batch job which takes data from an OLTP system and puts it into a Data Warehouse having first done some cleansing and conforming or it could be the sensors on your machinery in the warehouse which are constantly emitting data and you need to reason over those events and perhaps take action. We are experts in SSIS, Azure Streaming Analytics, Storm, Azure Machine Learning and Azure Data Factory   
  • Video
    The video is not available to view online.