SSIS Package: Dynamic metadata mapping before it runs
I have a simple SSIS package which will load data from a source to destination (say from ServerA to ServerB). To achieve this, I have used data flow task with OLEDB source & destination task and updated mapping for them. This approach works fine. But the problem with this approach is, whenever there is a change in data type or column names or introduction of new column, I have to touch the package. My question, is it possible to design a package in such a way that any changes will take care automatically by itself. i.e. I will have a kind of lookup tables where I will define the source and destination mapping details based on which the SSIS should perform the data flow execution. Is this really possible?