import excel file and stop at first empty row
Very new to DTS, I'm trying to import an excel file in a table.
My problem is that this daily excel file has a various length thus I don't want to specify the number of rows. Unfortunately if I leave 0 in the "Last row" of the "option" tab, DTS charges thousands of rows (when I only have around 300 today)
I also get an error because one of the column is a non-nullable key, because it imports empty rows...
How to tell DTS to stop at the first empty row ?