Free Sql Training – Intro to ETL using SSIS – Pragmatic Work

Watch the full Webinar here – http://pragmaticworks.com/Training/Details/Webinar-343

As we all know data is not static. It is constantly changing, constantly moving and just moving data from one place to another is a simple enough task. In this session Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world. We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination. Other topics to be covered include the types of transforms (partially blocking vs fully blocking), which transforms are right for which jobs and which transforms to avoid if you want your data to get moved quickly and efficiently.

Making Business Intelligent – http://pragmaticworks.com/