Too Many SSIS packages to manage!
Page 1 of 1
Too Many SSIS packages to manage!
My data warehousing team currently supports over 700+ ssis packages in production. We have your typical landing zone, staging area and production data warehouse. We also have a user testing environment which replicate the production jobs.
Although we have package templates and some reusable ssis packages, we still find ourselves creating new ssis packages each week (despite my protest). As you can imagine, this great number of package are difficult to manage and is ultimately unsustainable.
What I would like to discuss with this great group of like-minds, is other methodologies or techniques used in the real world to slow the growth of production packages or create a more metadata driven ETL process.
Thanks in advance for your thoughts.
re-Mark
Although we have package templates and some reusable ssis packages, we still find ourselves creating new ssis packages each week (despite my protest). As you can imagine, this great number of package are difficult to manage and is ultimately unsustainable.
What I would like to discuss with this great group of like-minds, is other methodologies or techniques used in the real world to slow the growth of production packages or create a more metadata driven ETL process.
Thanks in advance for your thoughts.
re-Mark
Remark- Posts : 1
Join date : 2015-10-05
Similar topics
» Using 3rd party Sort packages in ETL stream
» SSIS newbie
» HELP WITH SCRIPT COMPONENET, SSIS
» Looking for suggestions on ETL tools for DW/BI Project
» SCD object in SSIS
» SSIS newbie
» HELP WITH SCRIPT COMPONENET, SSIS
» Looking for suggestions on ETL tools for DW/BI Project
» SCD object in SSIS
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum