Centennial Tower

5F, Jl. Gatot Subroto No.24-25, RT.2/RW.2, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota, Jakarta Selatan, Indonesia, 12930

Grand Slipi Tower

Jl. Letjen S. Parman No.24, RT.1/RW.4, Palmerah, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta , Jakarta Barat, Indonesia, 11480

The City Tower

12F, Jl. M.H. Thamrin No.81, Dukuh Atas, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota , Jakarta Pusat, Indonesia, 10310

Explore Our Courses

Introduction to SQL Server 2012 Integration Services (SSIS)

 28 Hours
SQL Server 2012 Integration Services (SSIS) is a comprehensive ETL (Extract, Transform, Load) toolset provided by Microsoft. It allows users to solve complex business problems by copying or downloading files, extracting and transforming data from different data sources, and loading data into one or several destinations. This instructor-led, live training (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services. By the end of this training, participants will be able to:
  • Understand the principles of ETL and the role of SSIS.
  • Create, deploy, and manage SSIS packages.
  • Design and implement Control Flow to define the flow of tasks in a package.
  • Implement Workflow and set up constraints for effective task execution.
  • Construct Data Flows to extract, transform, and load data.
  • Work with Variables and Containers to enhance package flexibility.
  • Manage Transactions to ensure data consistency.
  • Implement effective error handling and debugging techniques.
  • Set up Logging for tracking and monitoring.
  • Handle Slowly Changing Dimensions for managing changing data.
  • Deploy a Package for production use.
  • Implement Security measures to protect sensitive data.
  • Utilize Scripting to extend SSIS functionality.
  • Apply Best Practices for efficient and maintainable SSIS solutions.
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
Read more...

Last Updated:

Testimonials (1)

The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.

Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)

Upcoming Courses

Other regions in Indonesia

Other Countries

These courses are also available in other countries
Online SSIS Pelatihan pada Jakarta, SSIS kursus pelatihan pada Jakarta, Akhir pekan SSIS Pelatihan pada Jakarta, SSIS pelatihan pada Jakarta, SSIS Instruktur Kepala pada Jakarta, SSIS kelas pada Jakarta, SSIS instruktur kepala pada Jakarta, Akhir pekan SSIS Pelatihan pada Jakarta, SSIS instruktur pada Jakarta, Selamat malam SSIS Pelatihan pada Jakarta, SSIS kursus privat pada Jakarta, SSIS Pelatihan pada Jakarta, SSIS pelatihan satu lawan satu pada Jakarta, SSIS kamp pelatihan pada Jakarta, Online SSIS Pelatihan pada Jakarta, SSIS di-tempat pada Jakarta