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 ?

Hey,

There's got to be some text stuff in those cells that makes DTS think there's data there. How is the Excel file created? You could follow up with a query that deletes empty records.

Brian

Thank you very much Brian
There was indeed some invisible excel formatting rubish