Course code: GOC637« Back

Microsoft SQL Server 2012 – Integration Services Advanced Topics

In this course, students will get to know typical operating problems of SSIS packages. They will try setting security of the access to data on Proxy accounts level. The second part of the course will deal with new features of SQL server 2012 from the point of Integration Services.

GOPAS Official Curriculum
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 11 400 CZK included in course price 20
Brno2 11 400 CZK included in course price 20
Bratislava2 420,00 EUR included in course price 20

User intensity level

Who is the course for

  • This course aims at IT professionals who already know how to design SSIS packages and who want to broaden their knowledge or are planning to start using SQL 2012.

After completing this course, students will be able :

  • To avoid security problems
  • To create proxy accounts
  • SCD using integration services
  • To use new SSISDB on SQL 2012
  • To use mass configuration with packages created in SSIS SQL 2012
  • To monitor the package working using reports in SSISDB
    • Required skills

      • Knowledge based on the content of the MOC 6235 course

      Teaching methods

      Expert instruction with practical examples, computer practice

      Literature

      Printed presentation

      Course Outline

      SSIS package use
      • Package monitoring
      • Advanced tasks and components
      • Installation of above-standard components into SSIS
      • Custom data source a custom data destination
      • Getting data from MySQL
      SSIS SQL 2012
      • New system of saving and management of SSISDB packages
      • Migration to project deployment model
      • Package monitoring using reports in SSISDB

            Previous courses

            no preceding courses

            Next courses

            no following course
            Tištěné nebo elektronické studijní materiály GOPAS

            Price:
            included in course price
            The prices are without VAT.