Hello everyone. It is my first post 
I have a question regarding deploying SSIS (dtsx) packages on database server. Now, I am creating sql jobs manually (by clicking in SQL Server Agent). Does Octopus provide any tool, steps, which could be helpful in my case? I see that generated SQL (‘Script job as’ option in SQL Management Studio) is to hard to be generated automatically. I feel that there is some other way in Powershell to do this.
Thank you for any response!
Hose.
Hi Hose,
Thanks for getting in touch! Unfortunately, there is no way directly in Octopus to help you with your SSIS deployments. However, I think I have just the thing to help you out here. Octopus has a community library for step templates that cover a wide range of needs. The link is below.
https://library.octopusdeploy.com/step-templates
I had a quick search and found the following step template. I’m not 100% sure how useful this is for your scenario but hopefully it is what you are after.
https://library.octopusdeploy.com/step-templates/bf005449-60c2-4746-8e07-8ba857f93605/actiontemplate-deploy-ispac-ssis-project-from-a-package
https://library.octopusdeploy.com/step-templates/efe39ac7-3ab8-4f99-bfdc-aba342278d1a/actiontemplate-sql-server-project-deployment-model-deploy-ispac
I also found the following community blog post that may help you out here.
Hopefully one of these links will give you the answers you seek in getting your deployments running smoothly.
Let me know how you go.
Best regards,
Daniel