Too Many SSIS packages to manage!

View previous topic View next topic Go down

Too Many SSIS packages to manage!

Post  Remark on Mon Oct 05, 2015 5:24 am

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

Remark

Posts : 1
Join date : 2015-10-05

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum