Problem with comma values in Comma Delimited File

Posted by on Jan 22, 2010 in SSIS | No Comments

Assume .csv file which columns delimited by comma ( , ) . and Texts delimited by Double Quote ( " ) like below: "Invoice Number","Invoice Status","Invoice Date of Service","Invoice Date Opened","Invoice Hold from printing/submission","Invoice Branch","Invoice Balances Adjustments","Invoice Balances Payments","Invoice Balances Balance","Patient Last Name","Patient First Name","Patient ID","Policy Payor Name","Invoice Detail Item ID","Invoice Detail Item Name","Invoice Detail ...

Read More