CODEWITHSUNDEEP
sql-serverssis
Rodrigo Souza
Rodrigo Souza

Reputation: 21

SSIS how to automatically map a newly added source column into all subsequent transformations and destinations

I have this ETL project in SSIS that collects some data in a Firebird database, makes some transformations, and insert them into a dimensional model in a SQL Server database. I had to make a change in the model adding some columns and had to map them manually in all components from source throughout the project. My question is: is there any way to automatically map newly added columns without having to check them manually in all subsequent transformation components?

Thanks,

Upvotes: 1

Views: 639

Answers (1)

Marius
Marius

Reputation: 208

We use BIML along with some metadata that we store in a database to generate our SSIS packages. If a new source attribute is introduced, we simply add that attribute to our metadata and regenerate the packages. The benefit with this approach is that you can regeneration multiple packages in one go.

Generating SSIS packages using BIML does rely on your solution using very strict, reusable patterns.

Marius

Upvotes: 1

Related Questions