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:
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
Columns
Data loaded to table
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?