CODEWITHSUNDEEP
sql-serverssisetlflat-filessis-2008
kaisquared
kaisquared

Reputation: 426

Column Delimiter not found Flat File Source

I'm trying to import the following text file into a database using SSIS.

https://www.dropbox.com/s/a1kicqv0rt5fuwy/output.csv?dl=0

I'm getting the following error:

[Flat File Source 1] Error: The column delimiter for try begin execute column "Column 45" was not found.

If I delete the second row in the text file, then the import is successful. However, as far as I can tell the two lines are identical. Can anyone help me understand where the difference between the two lines is and if there's some way for me to upload the file using a flat file source inside the DataFlow?

Edit:

Here is what my connection manager looks like

Upvotes: 0

Views: 6772

Answers (1)

Naveen Kumar
Naveen Kumar

Reputation: 632

When I try to import the file you provided in the dropbox using SSIS, it loaded the data into table successfully with out any error.

Kindly check the flat file connection manager settings.

General enter image description here

Columns enter image description here

Data loaded to table

enter image description here

Upvotes: 1

Related Questions