SSIS PKG Dropping .csv records
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,000042,CLASSIC FOODS,18600.00,61,5,0
2009,12,000049,ADVANTEX EXPRESS INC,4175.00,52,5,0
Problem:
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?
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,000042,CLASSIC FOODS,18600.00,61,5,0
2009,12,000049,ADVANTEX EXPRESS INC,4175.00,52,5,0
Problem:
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Reza Rad
could you paste structure of your table here?
ASKER
You were right. I deleted package and created again and records with ,, were not being dropped like before. Am not sure what I did wrong the first time but thanks for testing and telling me that it should not be dropping records with ,, in them.
ASKER
Thanks for asking to help to reza rad, but problem resolved.