• gbritton1 - Wednesday, May 17, 2017 8:55 AM

    Steve Thompson-454462 - Tuesday, May 16, 2017 10:52 PM

    Comments posted to this topic are about the item The Road to Database CI

    Thanks for the article!  Just wondering if you also use SSIS/SSAS/SSRS and have to integrate those into your CI workflow?  If so, how's it going?

    Thanks for reading and really good question. I'm sorry to say that the short answer is no: even though we do use SSIS quite a bit, we didn't dedicate the resources needed to operationalize those deploys to the same degree that we did db schema. We've started putting our greenfield projects into Git, but haven't done anything about automating deploys through Bamboo. There were a coupe of reasons, including the fact that we really only have one SSIS engineer right now, so there weren't many issues with tracking changes; and that our roadmap has us pivoting away from encapsulating ETL logic within SSIS. With that said, I do think that any shop that's serious about CI and has SSIS (or SSRS/SSAS) dependencies should most definitely look into building a process around them.