Clever Geek Handbook

SSIS Transfer Task that Handles Schema Changes

I am using SSIS with SQL Server 2k5 to create a migration task to copy all data from one database to another. This works well enough except for one problem: the original database will periodically have schema changes (usually just additions such as new columns), but the transfer problem seems to suffocate if the two schemas don't match exactly. Is there a way that I can use SSIS to first update the target DB with the schema of the original DB and then do the transfer?

0


source to share


1 answer


You can open the package programmatically and re-save it before executing. You can also programmatically create a package using the SSIS object model.



+1


source






More articles:


All Articles