How can pull the data from Excel(2007) source to Sqlserver destination

See more:

SSIS

Already i created package but did not it execute. where is it problem occurred i didn't get.

I am giving you all the steps how could i created package

Excel Source ---------------------Oledb Destination

---> 1) i open my project
---> then i took Data flow task in Control flow task
---> then click on Data flow task
EXCEL SOURCE:
----> then took Excel source in Data flow task
---->then right click on Excel source and click on Edit option
--->for create oledb connection manager i clicked on New option
---> then Browse and select my Excel file from particular folder
--->set the Excel version is Excel 2007 then click Ok.
--->set the Data Access mode is Table or view and set the Sheet1$ on name of the Excel sheet
---> i got the Excel data in the Preview option then i clicked ok
These are above all i configured of Excel source ---------------
OLEDB DESTINATION:
-----> I took OLEDB destination
----> then maped from excel source to oledb destination
----> right click on OLEDB destination then click Edit option
---> then created Oledb connection manager using some database
----> and set the Data access mode is Table or view
----> for 'Name of the table or view ' clicked New option
---> then create table Box is opened
----> in that i found table syntax . so in that i changed table name with some name instead of OLEDB Destination name
----> then click ok
----> here i got columns in preview option also
----> in mapping page columns already mapped then click Ok.
These are all steps of OLEDB Destination .
so one simple package has been created .
----NOW I WENT TO CONTROL FLOW
----THEN SELECT THE DATA FLOW TASK then Build the package
----then i did Debug(Execute) the package
here package did not executed.
In this i didn't get any Warnings and Errors also.
here i got red color Data flow task in control flow
and i got red color Excel Source also and not got any color on OLEDB Destination

ACTUALLY THIS IS HAPPENED IN MY PACKAGE .

SO PLEASE GIVE ME ANSWER FOR THIS PROBLEM.........