Class 6– SSIS What’s new in 2012

SSIS has come a long way since its first release in SQL Server 2005. It is used extensively around the world and can even be found in businesses that do not use Microsoft SQL Server as their primary RDBMS. The product continues to evolve and SSIS in 2012 has introduced new concepts that redefine how we deploy, log and execute our packages. Both the design time experience and the management aspects of the product have changed.

    Module 1 – Design Time
  • New Toolbox
  • Parameters (Project & Package)
  • Adornments
  • Shared CMs
  • Online / Offline CMs and validation
  • Upside down authoring
  • Undo
  • Copy and Paste Between Packages
    Module 2 – Deployment
  • Project Deployment Model
  • Configurations
    Module 3 – Execution
  • Environments
  • Parameters
    Module 4 – Management
  • SSIS Catalog
  • Performance monitoring
  • Querying
  • Identifying what happened, when and why
    Module 5 – Logging
  • Different levels of logging
  • SSRS reports
  • Extending
    Module 6 – Change Data Capture
  • Effective streaming of data
  • New components
  • How does it work
    Module 7 – Data Quality Services
  • Knowledge driven data cleansing
  • Integration with SSIS
  • The Future

Whether you have used previous versions of SSIS or are entirely new to the product this course will give you a good appreciation of what is possible and the processes around using the new features.

Dates: Thursday 25th April, 2013

Veune: Microsoft Auditorium, EPDC2, South County Business Park

Registration: 13.00 – 13.30

Class: 13.30 – 17.30

€100 if booked individually or €350 for entire series

For further information contact: events@prodata.ie or call 01 2933883

Register Now

Speakers

  • Allan Mitchell

    Allan Mitchell

    A SQL Server MVP since 2004, Allan is a very active member of the SQL Community, he presents regularly around the world and is a member of the SQL Bits organising committee. He has helped author books on SSIS and is passionate about data quality and data integration using products such as SSIS, DQS and StreamInsight His blog can be found at http://www.sqlis.com

Sponsors

  • Prodata SQL Centre of Excellence
  • Microsoft

Other Information