SSIS Data Flow Task Error for Flat File: Source Potential Metadata corruption during Validation

1
votes

I'm getting the following error in SSIS Data Tools 2013 when adding a Flat file source to Data Flow task. Tried adding it to new and already existing SSIS packages, not working in either cases.

TITLE: Editing Component

The component has detected potential metadata corruption during validation. Error at Data Flow Task [Flat File Source 1]: Failed to find any non-special error column in Flat File Source.Outputs[Flat File Source Error Output].

It may not be possible to recover to a valid state using a component-specific editor. Do you want to use the Advanced Editor dialog box for editing this component?

enter image description here Could not find any solution on the web.

Thanks,

2
ssisbusiness-intelligencesql-server-data-tools

2 Answers

0
votes

One of the solutions could be creating a new solution. It did work for me. But still not sure if there is a walk-around when need to add a flat file source to a data flow task in the existing project.

Please share your thoughts.

0
votes

Try this...

SSIS > Un-check "Work Offline"