Search code examples
sql-servercsvssisoledbflat-file

SSIS package validation error - flat file destination has no ID


i have a OLE DB SQL Command with a flat file destination and have added to column headers to the flat file but when executing package I get the below issue. is this because I have 2 extra columns in flat file?

enter image description here


Solution

  • Sounds like your package got corrupted. Your best bet is to drop and re-create the flat-file Destination Connection Manager, and then re-add the connection to the Destination.