Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being done in SSIS to integrate and align that information across the business. Most of the time, we import it and redirect it to find new rows through lookups and conditional splits, but what is we only need to import the first 10 or filter on a condition in the source?

This leads us to a specific way to query the worksheet that looks like below:

The important part here is the delimiter of the [ ] use. If you try to do this with them, you will get his error:

You can now filter and get information as you need without having to use SSIS to process more data than it needs to. Happy coding!

As always, post your questions on the BIDN forums.