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.

Subscribe to Download


Version
Download0
File Size1.18 MB
Create DateDecember 22, 2016
Last UpdatedDecember 22, 2016
Implementing Incremental Data Load And Inner Join in SSIS
Pivoting in SQL Server