Deploying *.dtsx packages.

hosed1933's Avatar

hosed1933

10 Jan, 2017 12:45 PM

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.

  1. Support Staff 1 Posted by Daniel Fischer on 11 Jan, 2017 01:30 AM

    Daniel Fischer's Avatar

    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...
    https://library.octopusdeploy.com/step-templates/efe39ac7-3ab8-4f99...

    I also found the following community blog post that may help you out here.
    https://kzhendev.wordpress.com/2015/10/14/deploying-ssis-projects-w...

    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

  2. Paul Stovell closed this discussion on 11 Apr, 2017 02:15 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

25 May, 2017 03:02 AM
25 May, 2017 02:43 AM
25 May, 2017 02:39 AM
25 May, 2017 02:36 AM
25 May, 2017 02:34 AM