SSIS error Flat File Source Error Output Column is DT_NTEXT RESOLVED - user error. This post can be removed.

• Steve Prevost

  SSC Enthusiast

  Points: 196

  More actions

  August 2, 2018 at 1:50 pm

  #77765

  I have a CSV file I get from a web source.  I created a connection manager that works as a non-Unicode file (meaning, the Preview will only display data when it is defined as not Unicode).
  When I create a Flat File Source task, and use this connection manager, it gives the error:

  The component has detected potential metadata corruption during validation.
  Warning at {7E6652E1-FEDF-47F8-83AE-64F364FFBF18} [Flat File Source [281]]: No rows will be sent to error output(s). Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s).

  Error at Data Flow Task [Flat File Source [281]]: The data type for "Flat File Source.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
  You can't change the data type of the output column.  Nor can you transform it with a data conversion task.
  The error goes away if I set the connection manager to use Unicode, but then I get no data, because it reads past the end of the file after the header row.

  I tried sending the Source Error Output to an empty text file, but the error remains.
  I also tried sending it to a dummy DB table, but the error remains.
  Thanks for your consideration!
  Steve