title: Excel Source SSIS
body: <p>I have an SSIS package with an Excel Source reads an Excel table.  I currently am using the <em>Table or View</em> Data Access Mode and it is literally reading every row in the worksheet, <code>1,048,576</code> which is the maximum. </p>
  
  <p>The source worksheet has an Excel table on it named <code>PSA_DATA</code>.  Why isn't this table in the <em>Table or View</em> drop down?  There is an option for the worksheet followed by <code>_FilterDatabase</code> but this fails when I run the package even though it pulls the correct data when I press Preview.  Wouldn't this make more sense than using the SQL Command and <code>SELECT * FROM [fact_PSA$Ax:Bx]</code>?  The whole reason we use Named Ranges and Tables in Excel is because they are dynamic!  Now I have to hard code the range in every time with rows numbers?</p>
  
  <p>What am I missing here?  Is there an easier way I am missing?  I just want to move an Excel table into a SQL table!  Why don't doesn't the most ubiquitous piece of software in the world easily talk to the second most ubiquitous piece of software in the world!?!?!</p>