In the data flow source, use 'SQL Command' and do something like:

SELECT *

FROM [Sheet1$B9:Q]