When I try to run SSIS package I got the following error [DTS.Pipeline]: input column "" (672487) has lineage ID 475474 that was not previously used in the Data Flow task. "component "Insert Destination" (671788)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" How can I fix it?

Check the destination database, either the structure of the table or data type of one of the columns must have changed. You must have got a yellow traingle with an exclaimation mark on your destination component. Double clicking that should auto fix the problem for you. If it does not then manually correct any mis-matches.http://btsbee.wordpress.com/