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.