Consulting Training Blog Careers About Us Contact Us

SSIS Training

See All Scheduled Courses

Intertech’s SSIS training courses cover the core SSIS tools including the use of the import and export wizard, understanding and using the Solution Explorer Window, and using the SSIS Package Designer.  For other SSIS training details see below course options.

Testimonials

I feel ready to jump into my new role at work and can do my job at a high level based on the training I received with Intertech.

Ben O

I took a three-day training course on SSIS packages. The trainer was very knowledgeable and took the time to thoroughly answer every question asked. He seemed personally invested in each of his students leaving the training feeling well-prepared to be successful with the tool.

Ben O

Excellent learning experience. Great value.

Brian O

I thoroughly enjoyed my class at Intertech. The instructor had a very deep understanding of the subject material, from it's history to it's current form, and was able to convey it to the class in an informative and enjoyable manner. He kept us engaged from the start and was able to share his knowledge with everyone in the class. Not only did Intertech provide a comfortable, high-tech training facility, it also provided the class with an exceptional instructor who actually cared that the students grasped the material. There is not enough praise I can heap upon Intertech for their training classes. They are simply the best.

Chris F

An excellent SSIS course with a nice introduction to data warehousing as well. Very helpful Thank you.

Christopher C

Course Finder

Return To Top
Filter Options
close

Training Category

  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See more Adobe Categories
  • See more Agile | Scrum Categories
  • See more Agile | Scrum Categories
  • See more Business Categories
  • See more Citrix Categories
  • See more CompTIA Categories
  • See more EC Council Categories
  • See more IBM Categories
  • See more IBM Categories
  • See more ITIL Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Linux Categories
  • See more Linux Categories
  • See more Machine Learning Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Network Categories
  • See more Network Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Oracle Categories
  • See more Oracle Categories
  • See more Programming Categories
  • See more Programming Categories
  • See more Software Testing Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more XML Categories

Scheduled Classes

Guaranteed To Run


Date

  • X
  • X
  • Please ensure that the End Date is greater than or equal to the Start Date.
  • Please ensure that the End Date is greater than the present Date.

Delivery

Location

- of results

Free Resources

Free On-Demand Videos: SSRS Report Builder Tips

Free SQL Server Whitepaper: Performance Tuning

Guide: Migrating Data Centric Applications to Windows Azure

MORE ON SSIS TRAINING

Other items covered in Intertech's SSIS training include:

  • SSIS tasks including looping and sequencing tasks.  Analysis services task, data flow task, data preparation task, workflow tasks, and SMO admin tasks
  • Containers including task host containers, sequence containers, for loop containers, and foreach loop containers
  • Data flows including data viewers, sources, destinations, and common data transformations
  • Variables, parameters, and expressions including understanding the various data types and working with expressions
  • Depending on the SSIS training course chosen, joining data including using the MergeJoin transformation, the Cache Transform along with use of the Cache Connection Manager
  • Scripting with SSIS including using the ScriptTask, the Script Component, and script coding and troubleshooting
  • Data warehouse loading including data profiling, extraction, cleansing, and using a master ETL package
  • Data cleansing including fuzzy lookup and fuzzy grouping
  • The Relational Engine including data extraction and data loading
  • Working with other data sources such as Oracle, Excel, and XML with web services
  • Tuning the SSIS Data Flow engine including data flow design and pipeline performance monitoring
  • Versioning
  • Error and event handling including breakpoints, logging, and error rows
  • In more advanced SSIS training courses, extending SSIS with custom programming including building components and component user interface and using SSIS with external applications including InfoPath, ASP.NET, and Winform apps
  • SSIS administration including deployment models, using of T-SQL, clustering, command-line utilities, and security

For the specifics of any offering, please select the outline from the SSIS training courses listed above.

Looking for Different Training?