The concept seem like import data from other format but you have to prepare your excel file in correct data.
Merry X'Mas and Happy New Year 2015
Wish all of you get lucky and happy life all of the year.
STEP-1
Prepare your excel file data in correct format.
STEP-2
Create new package and drag and drop "Data Flow Task" on Control Flow page
STEP-3
Double click on "Data Flow Task" box, then drag and drop "Flat File Source" then double click on "Flat File Source" box
then you will see the popup for configuration as image below
STEP-4
Click on "Browse" button to select excel data source file as the part you saved on computer
STEP-5
Click on "Column" at the left menu for check fields on excel file, after that click on "OK"
STEP-6
Drag and drop tool on menu left is "OLE DB Destination" then select connection (you can see here how to connect to database)
and select table destination
STEP-7
Click on "Mapping" on the menu left for check your data field, you have to select data to be match with destination
STEP-8
If you see the error after mapping data, please be sure that your data type, data length is the same as table destination
if not, you have to convert data (you can see how to convert data here)
NOTICE!
This is very important, if your excel file have empty value, you have to check and convert to zero install (in case that column is numberic)
