Post reply

Flat File source - inconsistent data

  • June 29, 2010 at 9:09 am

    #220641

    Hi,

    I have a flat file which I need to process via SSIS(Data Flow Task->Flat File source), but have at least one record where the data is inconsistent.

    This is an example to the data:

    "ABC123","""Garrion"", Barrhead Rd., Neilston, Glasgow",""

    The text qualifiier is ", so you can see the three before 'Garrion' and absence of any before 'BarrHead' are throwing it out and giving me the error

    [Flat File Source [1]] Error: The column delimiter for column "telephone" was not found. , and then the row number of the invalid data.

    I've tried configuring the Flat file source editor to redirect invalid rows, but it still fails. I've also tried 'delay validation'. But that didn't work either.

    Thanks in advance.

    Paul

  • June 29, 2010 at 10:52 am

    #1186531

    I'm not sure of a good way to work around this with the component itself, you could use a script component as a data source and read and format the output into the pipeline yourself.

    CEWII

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

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