BH Technologies® Case Study
SQL Server Integration Services
Challenge
Our client, a county located in California, needed SQL server integration services (SSIS).
Solution
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
• 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
