We utilize a clustered SQL Server setup at the foundation which requires that any package changes be propagated to two separate locations on the file system. In addition we have a separate financial data warehouse where we use SSIS packages that are deployed to the Integration Services Catalog (SSISDB). I realize the catalog is a relatively new approach but I suggest that CRM migrate its packages to the catalog. This greatly reduces administration burden to the DBA as well as management of permissions, etc.
| Organization Name (Please enter full organization name) | FSU Foundation |
| Reported Version | 4.0 |
Our financial warehouse comes from Financial Edge so it would be extremely helpful to be consistent with this approach across all Blackbaud products.