Using Excel as input to a package.
Make sure to add a column header to the Excel file with your input data and check that the sheet's name is SHEET1 in the bottom left.
In your package properties -> Steps tab, click the New... button to create a new task.
Click through to the Build a List of Urls step and select the Excel Spreadsheet option.
Choose the bottom radio button to connect to an existing spreadsheet.
Check the box "The existing file's first row is column headers."
Complete the wizard and open up the new task's properties.
Go to the File List or Form List tab and change the query:
SELECT [F1] FROM [SHEET1$]
to
SELECT [TheColumnHeaderYouChose] FROM [SHEET1$]
Now hit the test link on the bottom right to test your query.
Good Luck!