Importing from excel with missing data
very new to DTS and would appreciate some help.
I would like to import an excel s/s to a number of tables. Unfortunately the s/s has gaps where the creator of the s/s has left out the ID field, where it is a repeat of the field above i.e. row one will have an ID entry in field1, if row 2,3,and 4 are entries for the same ID, then the field is left blank.
Would the best way be to audit the s/s beforehand to ensure that all fields are filled or is there a way fill these in during the DTS process? if so, any example code would be appreciated.