OpenCourser
Learn skills that shape your future
Visit OpenCourser.com
Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.
Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.
Topics include:
Save
Verified partner policies & purchase protections
1-month (30-day) free trial for new members with unrestricted access to over 20,000 expert-led courses (note: canceling trial ends access immediately).
Cancel anytime online before the 30-day trial ends to avoid charges. Subscriptions auto-renew; canceling stops future renewals. Refunds for accidental renewals may be considered within 7 days only if zero content was accessed.
Direct certificate and skill badge integration with your official LinkedIn profile, taught by vetted industry practitioners, backed by Microsoft security.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
