Specifying Multiple Text Qualifiers For A Flat File ETL

• joshdbguy

  SSCertifiable

  Points: 7707

  More actions

  December 10, 2014 at 4:41 pm

  #301751

  Is there a way to specify multiple text qualifiers for an ETL data flow. In a bunch of files I'm trying to load into SQL, there are a few lines in each one that look like this,

  "test data 1", "test data 2", "test data 6" tall"

  So a double quote (") text qualifier works except for this one scenario. Is there any way around this without doing some crazy file manipulation?

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  December 11, 2014 at 1:00 am

  #1763963

  Is there any way around this without doing some crazy file manipulation?

  1) Use a delimiter which does not appear in your data.

  2) Use SSIS 2012 onwards. See here.

  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