How to execute .dtsx file on the server

Hello,

I need to run Infrastructure tests on server where I have my SSIS project deployed (.dacpac). Infrastructre tests file is of .dtsx extension. How can I do that with octopus deploy?

Hi @etrochimiuk,

Thanks for getting in touch!

We don’t have any built-in steps that can do this, however, there several community steps that may be what you’re looking for. E.g https://library.octopus.com/step-templates/f69ea863-ab61-4c58-bcbe-a133450113c9/actiontemplate-ssis-deploy-sql-agent-job

If the community steps aren’t exactly what you need they should hopefully be able to form a starting point for creating your own step template.

Regards,
Paul