February 15, 2011 at 3:03 am
Dear All,
I am extracting the Address fields from the varchar field and its separated by comma in the address field to a .csv file format using SSIS.
When loading from the SSIS .csv file one field is shifting because of one comma in the address field.
How do we avoid this.
Thanks,
Gangadhar
February 15, 2011 at 3:08 am
Unless the offending text fields have their own delimiter, eg:
"kdfjgasdg, dasfsjfg ", 5,10,"dkjhkh, asdkjhaksdj"
There is not much you can do, other than asking whoever provides the information to help (by adding a text delimiter, changing the field delimiter to something else, or stripping out the commas at source).
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply