- 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!