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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | dotnet2010Starting Member
 
 
                                        7 Posts | 
                                            
                                            |  Posted - 2011-12-30 : 09:04:56 
 |  
                                            | HiI 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 exampleTable Original table TBA - new table TBAExtra Also I have archiving mechanize  that copy the data from TBA to TBAArchive table. |  |  
                                |  |  |  |