Solutions / Microsoft / Integration Services (SSIS)

What You Can Accomplish When Properly Utilizing SSIS

loading and transforming billion-record data sets from multiple data sources

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

implementing complex data transformation using .NET script

migrating existing code bases from package to project deployment mode

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

SSIS is designed to:

Consume data from heterogeneous data sources

Transform data with multiple built-in transformation tasks or custom developed tasks

Load the 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. 

YOU CAN UTILIZE AN INTEGRATION SERVICES SOLUTION CUSTOM-TAILORED TO YOUR OBJECTIVES

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