Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Salesforce Column Data with Apostrophes

I have noticed every time I do a SF_REPLICATE to SQL Server DB and some column values have an apostrophe, the column is not imported and the data is incorrectly mapped to the next available column.

Eg if a 3 column SF Object
id | Name | Town
1 | O'Neal | Alaska

It will import the data and totally ignore the Name Column. It doesn't throw an error to this effect!
1 person has
this question