I have a SSIS pkg that gets records from a .txt file from a ftp site and then writes them to a sql table.
The .txt file contains comma separated values:
YYYY,MM,CUSTOMER NUMBER,CUSTOMER NAME,YTD Billings,DSO,LOC,Total Risk Weight
2009,12,000006,CIBA SPECIALTY CHEMICALS CAN,1110.00,,20,0
2009,12,000049,ADVANTEX EXPRESS INC,4175.00,52,5,0
If there is nothing in a field, ( ,, ) like on the first rec under heading rec, 1110.00,,20,0
then this record is not recognized in ssis and is not written out to the sql table.
The user who created these .txt files says the fields with ,, where null fields...
Anyway to correct this problem in ssis package so these records are recognized and written to the sql table?