Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Changing database scheme (extend tables)

Author  Topic 

dotnet2010
Starting Member

7 Posts

Posted - 2011-12-30 : 09:04:56
Hi
I want to add new columns to exists database that works with SSIS,SSRS and asp.net application, I wand to do that in the best way without the need to do a lot of changes at SSIS since I know that any change at database will make the SSIS packages stop working.
I thought about adding new tables that extends the exists ones example
Table Original table TBA - new table TBAExtra
Also I have archiving mechanize that copy the data from TBA to TBAArchive table.
   

- Advertisement -