This is a step by step practical guide created for beginners who want to learn how to use the SQL Server Integration Services 2012 to Load the data. Here I created a sample CSV data file "Employee" which we will load into a table dbo.Employee in the database. During this exercise we will use some of the basic SSIS transformations like Source Adapter, Derived Column transformation etc. The Zip file contains Source data file in source folder, T-SQL script for Employee table & SSIS Solution.

 

Please rate this Code by clicking rating star above.