Hi, I am looking for a way to ensure all data is systematically captured during our archiving process. Example: -- TableA contains 5 fields. -- TableA's 5 fields are archived. -- Later, TableA's has a field added. --Currently, we have to go into the package and add the new file manually. Is there away to systematically handle this? Sql Server 2008 R2 Cum 3. Using SSIS for archiving. Thank you for your help.

Check these one: http://munishbansal.wordpress.com/2009/06/09/dynamic-columns-mapping-%E2%80%93-script-component-as-destination-ssis/latha

Hi, The simplest soultion would be the following SQL Query. Following query works fine if the source and destination table are similar structure and the columns are in same order. whenever there is s change in the Source table structure, we have to make the same change in the destination. This is known task :). I am giving just an hint. insert into <Destination Table> select * from <source Table> Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com