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!