Akomarek

Unregistered less info
11 reputation
1
bio website
location
age
visits member for 1 year, 9 months
seen Oct 22 '12 at 18:43

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