Okay, not sure if this is the right way to do but i tried this.

Step 1: Created a table in Sql Server

Step 2: Created a data flow task - with excel file as source and Oledb as destination. this transferred all rows in newly created Sql table

Step 3: Created a second data flow task with OleDB source and Share Point list as destination.

Package executed fine but i still dint see the date values in SharePoint list.