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".