Archive Data Warehouse Data
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.
May 17th, 2011 12:23pm

Check these one: http://munishbansal.wordpress.com/2009/06/09/dynamic-columns-mapping-%E2%80%93-script-component-as-destination-ssis/latha
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 12:35pm

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
May 17th, 2011 11:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics