February 22, 2012 at 7:59 pm
Hi, can anyone help me how to handle if there any change in source field name and table name without changing my package. I heard that there facade concept, but not sure how it works.
February 27, 2012 at 2:54 pm
If you're accessing data using the table name then you have the option of renaming the table and replacing it with a view of the same name with the interface you want. However, that would likely leave other applications that are expecting the table changes you described left to deal with changes.
Going forward you should consider using views to access data from within your SSIS packages instead of directly referencing the base tables. If you only perform data access against views then you can modify the view when the schema of the underlying table changes allowing your SSIS packages (or any other apps that use the views) to continue to function without any code changes.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply