May 17, 2010 at 6:52 am
This is an old one but has anyone had any luck with importing csv files that have double quote text identifiers where double quotes are also used in the data to be imported? What can be done for situations such as this: ""Example data to be imported"" where you want the imported data to look like "Example data to be imported" within the table.
May 17, 2010 at 10:55 am
Try '"Example data to be imported"'
May 17, 2010 at 2:25 pm
This file is sent to us so we don't get to choose the identifiers. Although we are putting a call out to those that produce the file to see if it can be changed to see if that would help. Any other suggestion?
May 17, 2010 at 2:58 pm
You can use an SSIS Expression to replace the double quotes with single quotes.
1. Add a Derived Column transformation to the data flow and connect it to the Flat File Source.
2. Configure the Derived Column transform as follows:
- Select Replace <column name containing data with double quotes> from the Derived Column list box.
- Add the following expression to the Expression text box, to search for the double quotes and replace with single quotes:
REPLACE([<column name>],"\"\"","\"")
I tested this on my machine, it the expression did work.
May 18, 2010 at 2:54 am
ok i got it ^_^
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply