Utilize the SQLServer Integration Services Catalog to host SSIS Packages instead of the file system.

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.

  • Guest
  • Jan 21 2016
Organization Name (Please enter full organization name) FSU Foundation
Reported Version 4.0
  • Attach files
  • Jeanne Pecha commented
    January 21, 2016 20:56

    Our financial warehouse comes from Financial Edge so it would be extremely helpful to be consistent with this approach across all Blackbaud products.