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