SSIS CI / CD流程 [英] SSIS CI/CD process

问题描述

我们目前正在使用TFS作为SSIS包的源代码控制，并在我们自己的专用SQL服务器上将它们部署在Test / QA / Prod中。 

Hi, We are currently using TFS as source control for our SSIS packages and deploying them in Test/QA/Prod on our own dedicated SQL servers. 

现在我们计划从TFS迁移到GIT，并为我们的SSIS包实施CI / CD流程。我们能够将它们转移到GIT，但不确定实施CI / CD流程的最佳方法/工具是什么。

Now we are planning to move from TFS to GIT and also implement CI/CD process for our SSIS packages. We are able to move them to GIT, but not sure what is the best approach/tool to implement CI/CD process.

你能来吗？请提供相关见解？

Can you please provide insights on it?

谢谢

RaviRaj

推荐答案

您好RaviRaj，

Hi RaviRaj,

只需将您的CI / CD管道作为脚本或连接到Git事件的触发器作为标记部署运行。可以使用dtutil.exe部署项目或软件包（不确定您拥有哪些版本）

Just run your CI/CD pipeline as a script or a trigger hooked to Git events as tag deploy. The project or packages (not sure what versions you have) can be deployed using dtutil.exe

这篇关于SSIS CI / CD流程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！