October 22, 2019 at 5:18 pm
I have a SQL Server 2016 that runs on two node clusters.
And, it has SQL Server Engine and SQL Server Integration Services.
I took over the DBA responsible from previous DBA.
And the SSIS ran into many issues.
And I was proposed to move the SSIS server out from the cluster environment.
Provision a new VMs -à To be completed by Server Team
Production Environment VM
SQL Server version = MS SQL Server 2016
Memory = 32 GB
Disk Space =
Setup and Install MS SQL Server Integration Services
I am not hundred percent sure that by setting up only SQL Server Integration Services on the new server.
Will the SSIS Project Deployment Model that used ispac file possible or work?
Or
Can I still deploy the SSIS package through SQL Agent jobs?
Questions:
Can SSIS still work when the SQL Server clusters failed over from Node1 to Node2?
Does SSIS 2016 support clustering?
Would someone give me light and help.
Thank you so much in advance.
Best regards,
Edwin
October 23, 2019 at 6:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 23, 2019 at 7:31 pm
I can answer some of your questions. It is a good decision to not run SSIS as part of the cluster, since it's not a cluster aware process and has a number of documented issues. It does not look like Microsoft is planning on making it cluster aware either:
When you install SSIS on your new VM, it's still recommended to also install the database engine on that VM, and it will allow you to schedule the packages to run in SQL Agent:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply