Home Forums SQL Server 2005 T-SQL (SS2K5) SSIS + Flat File Source + ignore invalid rows + CSV RE: SSIS + Flat File Source + ignore invalid rows + CSV

  • This is a good question...someone probably has an answer but I don't. If I may, I'd respond with a comment. First, I've never seen one like this, stoked that I don't have a file that's in that bad of shape 😀 Second, without all of the delimiters, how do you tell which column goes where?

    Example:

    Your data

    2,raj,delhi,4,4

    3,2

    2,raj,delhi,4,4

    So for this row (PK violation notwithstanding)

    2,raj,delhi,4,4

    suppose you get this?

    2,4

    How can you tell whether the first "4" is for the fourth attribute or the fifth?