Data loading from various source is a common task for data centric application. SSIS package is a very handy and easy to learn tools to load data from various source like excel, flat file or other database. In this SQL Server Integration Service(SSIS) series we try to learn, how to create, deploy, configure and monitor SSIS package. In first article of the series we will create a simple SSIS package which extract data from excel file then load the data to a SQL server database.
Initial Setup
Before we do anything else, we need to create necessary table to which we want to load data from the excel file. Lets create the.
CREATE TABLE DataLoadTest
(
Id int IDENTITY(1,1) PRIMARY KEY,
Name nvarchar(500) NULL,
FirstColumn nvarchar(500) NULL,
SecondColumn nvarchar(500) NULL,
GroupOrder int NULL
)
GO
