Home Forums SQL Server 2008 SQL Server 2008 - General Importing a file getting Error: The column delimiter for column "MyColumn" was not found. RE: Importing a file getting Error: The column delimiter for column "MyColumn" was not found.

  • I've found a couple of problems so far. The package I put together first fails at Row 1682. If you suck the txt file into Excel you can see what is in row 1682 (search for Trames in the text file): it's empty when you look at it in Excel because all it has in it is three commas, which are delimiters. If I take that row out, the package runs further, down to row 1807 which only has one field in it. I could take that out and I'm sure it would run further. You may have to use a script task to scrub the data for you. I ran into a problem like this. I had a text file that some times had x columns in it, sometimes Y. I wrote a script to determine which type of file I had then use code to parse the variables out.