title: Import data from Excel using SSIS without knowing sheet name
body: <p>I have a spreadsheet that is updated by another server (out of my control) and I need to automate bringing that data into SQL 2005.  The data is always the first page of the spreadsheet.  However, the name of that sheet changes depending on the number of rows.</p>
  
  <p>Is there a way to run an SSIS job that pulls in data from Excel without knowing the sheetname beforehand?  It seems to rely on the sheet name as the data source, but I'm looking to tell it "sheet number 1" or something similar.</p>