SSIS PKG Dropping .csv records

thayduck
thayduck used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You should not have to do anything, unless the column in question is set to NOT NULL in the database, you should have no problem.
I just tested your file and had no problems.
 
Reza RadConsultant, Trainer

Commented:
could you paste structure of your table here?
thayduckProgrammer Analyst

Author

Commented:
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.
thayduckProgrammer Analyst

Author

Commented:
Thanks for asking to help to  reza rad, but problem resolved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial