I am attempting to import a flat file and have come accross and issue that I do not know how to fix in SSIS. The issue is that some of the text fields use quoted identifiers. This is not an issue in itself. The problem is they also use quotes as escape character if quotes are on the field.
So I see instances of "" because inside the quoted field is a quote. How do i specify an escape character?
Unfortuanately, the current Flat file parser does not know how to parse embedded qualifiers.
As a workaround, you should probably keep the qualifiers in the flat file source and process them downstream using either the script component or Derived Column.
Thanks.
No comments:
Post a Comment