Monday, 15 June 2015

sql server - Importing flat files in SSIS, error handeling missing delimiters -


I am importing flat files to a SQL Server DB. I have a dataflow task for each loop in which there is a flat file source, OLEDB destination and flat file destination for errors. I have set the error output settings to redirect the rows, I know that one of the flat files is the fault delimiter in the row (rows). The quote and the comma are the reason it's hanging. I have found similar solutions but they always have Do not have to work, like always.

Thank you!

foreachloop

row with error


No comments:

Post a Comment