SSISDB/SSIS in docker linux containers?

[scoobs76]

I was wondering if there are any solutions or sample docker files available that will get SSIS loaded to a SQL Server image for running on a linux cointainer? I began exploring "https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ssis", but these scripts don't appear to be able to run via a Dockerfile. Please advise if I am wrong. Thanks.

[twright-msft]

Integration services is not yet supported in a container.

[scoobs76]

Any time estimates for this support? Thanks.

[twright-msft]

Not in the near term.

[YodaNinja]

We just came across this GitHub post...

We were able to run the same scripts for installing SSIS in a Linux Docker container.
Although at the end it does state the error:
"Failed to get D-Bus connection: Operation not permitted
Attempting to start the telemetry service failed."

Running dtexec was working ok in our tests.

Though, now after reading the above, we are considering that we will need to deploy in VMs instead.

We have searched through several Microsoft documentation, including the SQL Server 2017 white paper, looking for an indication and details that SQL Server Integration Services is not supported in a Docker container, but have not found any.

Can you please give some more details on SSIS not being supported in Docker containers, or point us to documentation stating so.
We would rather have more to reference than this GitHub post, for the change in deployment to VMs.

Many thanks!

[twright-msft]

The absence of something stating it is supported in documentation means it's not supported. (yet) :) If there is enough demand for this we can talk to the SSIS team about trying to get it done though. If anybody else is interested in this, please thumbs up here and we'll loop in the SSIS team.

[mikesurel]

If SSIS was supported on containers, would that be both windows and linux containers? We have use cases for both. Thanks.

[twright-msft]

@mikesurel - TBD. I see here that 8 people have upvoted this now. I'll shoot an email over to the SSIS team letting them know about the interest here.

I'd love to convince my office to move SSIS into a container so I can just have them spin up and down as packages needed to fire on a schedule. Or something along those lines.

[warrenrumak]

Containerized SSIS would be a significant benefit for our organization.

[TayiSaiKishore]

We are waiting for SSIS containerization because it will be next big move for most of the organizations.
Hope SSIS Team started working on it. If not, requesting to engage them.

Thanks In Advance.

[dentaku65]

We are waiting for SSIS containerization too.

[nsbradley88]

This would be a huge step. We're relying on server pools running SSIS, containerization will take it that one step further to abstract the workloads.

[AHulshoff]

In terms of scalability, it would be a huge step forward in using SSIS. At the moment we have SSIS in an out-scaling configuration on VMs. Unfortunately, this does not give the ability to automatically scale out when more resources are required. Containerizing SSIS will make an out-scaling configuration so much more powerful.

[luismiguelsanroman]

Hi,

I don't want to bug you with this topic but Do you know if SSIS will be available in Containers this year?

Thanks!!

[twright-msft]

We generally operate in 6 month planning/dev cycles. The work to put SSIS in containers is not committed by the SSIS team for this 6 month period which ends at the end of the year. Planning for the next 6 months will start in another couple of months so now is a good time to start building up the demand and use cases for it! :) I dont see a feature request for SSIS in containers over on the SQL Server User Voice site yet so it might be a good idea to get this request logged over there and get some additional upvotes and input there. https://feedback.azure.com/forums/908035-sql-server