SSIS 2012: Is it possible to use the SSISDB Integration Catalog and Project Parameters in a SQL 2012 clustered environment?
Techies--
I know that SSIS hasn't been designed for clustered environments. In our 2008 R2 environments, we resolved the issue by deploying dtsx and dtsConfig files to a mutual share. This is our first deployment to a clustered 2012 environment. I don't
want to lose the native reporting features and project parameter environments available in 2012. How do I approach this?
September 9th, 2015 4:17pm
September 9th, 2015 4:33pm
Tom,
Are you thinking always on would be an alternative to a cluster setup? Unfortunately, the server configuration as it exists (clustered) is what I have to work with. I don't really need SSIS to failover as I would other more failover friendly/assigned resource--I
just need it to get installed to the SSIS integration catalog.
September 9th, 2015 4:59pm