Post reply

Specifying Multiple Text Qualifiers For A Flat File ETL

  • 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?

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply