(678) 835-8539 info@key2consulting.com

Solutions / Microsoft / Integration Services (SSIS)

We can design and deliver a custom Integration Services (SSIS) solution that will empower you to:

load and transform billion-record data sets from multiple data sources

customize an auditing and logging framework to help monitor and troubleshoot integration services executions, as well as trend execution performance over time

implement complex data transformation using .NET script

migrate existing code bases from package to project deployment mode

integrate SharePoint as a source for data warehouses to replace cumbersome, shared Excel documents

SQL Server Integration Services (SSIS) is designed to:

– consume data from heterogeneous data sources

– transform data with multiple built-in transformation tasks or custom developed tasks

– load data to multiple built-in 3rd party or custom-developed destinations

A Brief History of SSIS (Integration Services)

Microsoft first introduced Integration Services (SSIS) alongside SQL Server 2005 as the replacement for Data Transformation Services (DTS).  Since then, Integration Services has changed and matured with each new SQL Server version, but perhaps none more than the SQL Server 2016 release of Integration Services.  Incremental package deployment to the SISSDB catalog, support for Hadoop file system (HDFS), numerous Azure features such as Azure storage connectors, and many other features that the database developer and database administrator communities have been clamoring for are included in this release. 


If you’re considering implementing or customizing a new or existing integration services solution to better fit your business, we can help.