• I had an 11 million row CSV file that had a small number of rows where the delimiters were wrongly set for some reason. I got the error:

    [Tx File [1]] Error: The column delimiter for column [X] was not found.

    I couldn't get SSIS to send these rows elsewehere during the load because (I'm guessing) the lack of delimiter meant that it couldn't skip onto the next row.

    In the end I imported it to an old instance of SQL 2000 which is a lot more forgiving and then transferred it and began investigating and cleaning from there.

    regards, Matt