I am developing a rather large ETL solution using SSIS. So far I have been building everything inside a single package but it occurred to me that perhaps I ought to check and see if that is wise. Are there performance gains or scale reasons to
split an ETL into multiple packages and then have a master package that calls each one and keeps them in sync? I assume building everything in one package is OK?
Thanks in advance...
View Complete Post