SSIS is strongly types about metadata.
For example: you create a simple dataflow with a source, derived column and destination. Change something in the destination table: package fails. Change something in the source? Package fails. Every change in the metadata makes you re-opening all the components, so that the metadata can be refreshed. So also the derived column. Metadata changes do not propagate through the dataflow. This has the following important consequence: you cannot make the SSIS dataflow dynamic easily (at least not out of the box). You cannot dynamically change destinations or sources, unless they have the exact same metadata structure. If you load flat files with the exact same number of columns and datatypes with the same header, it will work. If one column is missing or there is an extra column, your package will fail.
Please refer to meta data in ssis and Data Flow.
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.