I have a collection of 109 tables that have the date stored in a header row, then a variable number of data rows, then a footer row.
I want to extract only the date from the header row, and discard the remaining rows.
I tried to select one row using row sampling, but this produces a random row.
How do I get the first row, from a flat text connection, in SSIS?
View Complete Post