The Basics of SSIS

Just starting out in data administration and development and looking for an introduction to SQL Server Integration Services (SSIS)? In a recent webinar, Sr. Product Engineer, Philip de la Cal, discussed all the basics of SSIS. This one hour introductory-level demonstration covers all the basics you’ll need to get started on your journey into SSIS.

SQL Server Integration Services, commonly called SSIS, is a platform for implementing data integration processes into system files and databases. By creating high performance workflow and data integration solutions, you'll be able to design, implement, and manage complex ETL (extract, transform, load) applications.

In this webinar, Philip covers SSIS fundamentals and basic terminology (so you can “talk the talk”), as well as why you should use SSIS, utilizing tasks such as data source integration, built in tasks for loading a data warehouse and data cleansing. He also goes over some use cases and discusses the development environment. Included on the video are demos on creating your first control flow and working on the data flow.

This introductory-level demonstration is a great place to get a brief introduction to SSIS as you embark on your first steps into data administration and development. Watch the complete webinar below.

Interested in deeper dive SSIS training? Our On-Demand Training platform has you covered, with courses in SSIS (Intro to Advanced), as well as over 30 other courses on Business Intelligence, Power BI and SQL Server Administration. Get started with a free trial today!