Reputation
Top tag
Next privilege 20 Rep.
Talk in chat
Badges
2
Impact
~1k people reached

Nov
13
awarded  Popular Question
Oct
22
comment SQL column goes from first to last position in output
Thank you Jon, That id correct that part of the output; however, now the flatfile still contains the incorrect mapping from the previous run. I get the following error now: Package Validation Error Error at Data Flow Task [SSIS.Pipeline]: input column "CLIENTID" (165) has lineage ID 20 that was not previously used in the Data Flow task. Error at Data Flow Task [SSIS.Pipeline]: "component "Flat File Destination" (154) failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Oct
22
awarded  Student
Oct
22
asked SQL column goes from first to last position in output