I have several DTS packages in a database that imports data from excelsheets.

When I was testing a newly built DTS I found out that I was missing a couple of rows compared to the excelsheet. Not good.

When designing the DTS and putting a "Transform Data Task" between the excelconnection and the database, I get to choose which sheet I'd like to be connected to. The problem is there are only one in the excelsheet but the dropdown list shows THREE different sheets to choose from in "Table/View".

1. 'PM_Menu'$FilterDatabase
2. 'PM_Menu'$
3. PM_Menu

If I choose the first alternative I get an error, second one gets all my rows into the db, if I use the third alternative (same name as my sheet) I loose some rows.

What's the difference between these alternatives?