March 13, 2013 at 12:43 am
I have a CSV file with field delimiter as COMMA (,). The package is working without any issues for few source files, but fails when the field value in the file contains “COMMA”.
Note: I have no control over source file. Is there a way to handle it in SSIS?
March 13, 2013 at 1:15 am
dfine (3/13/2013)
I have a CSV file with field delimiter as COMMA (,). The package is working without any issues for few source files, but fails when the field value in the file contains “COMMA”.Note: I have no control over source file. Is there a way to handle it in SSIS?
I am not sure ... but, an option would be to route the failed row to a flat file destination.. and you can clean the data afterwards...
it the delimiter is "," and the data can have commas , then it's not the correct delimiter after all ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy