BH Technologies® Case Study

SQL Server Integration Services


Our client, a county located in California, needed SQL server integration services (SSIS).


Beacon Hill Technologies was selected to deliver this SSIS project for the client, which included Workday application implementation. We deployed an SSIS administrator and developer from June 2017 to March 2018 to provide design, development, and post-implementation support for SSIS. SSIS was used for various data interfaces and reference tables to and from the Workday application.

The Results

Our SSIS administrator and developer assisted the county with the SSIS project responsibilities listed below:
• Installing and configuring SSIS according to best practices
• Guiding the design and implementation of SSIS architecture
• Reviewing integration services projects, packages, control flow elements, connections, variables, event handlers, and log providers with county staff