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

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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