Hands-On-Lab: SSIS Data Loading – Part 1

Extracting and loading data is one of the first step in an ETL process. SSIS allows to extract and load data from many different data sources. However, in this lab, we’ll learn to extract data from Excel and XML source. In the first exercise, we’ll learn to extract and load data from multiple sheets in an excel file. In the second exercise, we’ll learn to extract data from an XML source and in the third exercise, we’ll learn to optimize data insertion using from a CSV file source to SQL Server using the bulk insert task.

Exercise 1: Load data from multiple sheets of an Excel file
Exercise 2: Load data from XML files
Exercise 3: Load data using Bulk Insert task

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.