Microsoft's platform for data integration and ETL. It moves, cleans and transforms data with packages that run on SQL Server or in Azure.
Title graphic: SQL Server Integration Services (Product)
Description
SQL Server Integration Services (SSIS) is Microsoft's platform for building enterprise-level data integration and data transformation solutions. It solves business data problems such as copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.
As an ETL tool, SSIS extracts and transforms data from sources such as XML files, flat files and relational databases and loads it into one or more destinations. It offers many built-in tasks for control flow and transformations for data flow. Graphical tools let people build packages without writing code, and an object model allows packages and custom tasks in code. The SSIS Catalog is a database that stores, runs and manages packages.
SSIS is part of SQL Server and installed through SQL Server setup. The page lists the SSIS Integration Runtime in Azure Data Factory as a supported environment, so packages can also run in Azure. The page does not name target users. From the tasks described, data engineers, ETL developers and database administrators use it. SQL Server Agent often schedules package runs as job steps.
Enterprise integration is usually invisible until it breaks, and deterministic workflows struggle with the unexpected. This episode is for architects and integration developers who want to understand Azure Logic Apps, connectors, identity and observability…
Relationship map of SQL Server Integration Services: linked topics
Related topics in brief
Microsoft· Developed by · Organization Microsoft Corporation is a technology company that develops software and cloud services such as Microsoft 365, Azure and Dynamics 365.
Analytics and BI tool· Is a · Category A tool for analysing data and building reports and dashboards.
Developer tool· Is a · Category A tool that helps developers write, test and ship software.
Microsoft SQL Server· Related to · Product Microsoft's relational database management system that uses T-SQL. Its engine also underpins Azure SQL Database and Azure SQL Managed Instance.
SQL Server Agent· Related to · Product A Windows service that runs scheduled jobs, alerts and notifications for SQL Server and Azure SQL Managed Instance.
Azure Data Factory· Related to · Product Microsoft's cloud-based data integration service for orchestrating data movement and transforming data at scale with pipelines, activities, linked services, datasets, integration runtimes and triggers. Data Factory in Microsoft Fabric is described by Microsoft as its next generation.
Microsoft Fabric· Related to · Platform An all-in-one analytics platform that combines data engineering, data warehousing, real-time analytics and Power BI on a shared storage layer called OneLake, billed through shared capacity.
Power BI· Related to · Product Microsoft's business intelligence tool for turning data into interactive reports and dashboards. Semantic models define the data and measures, and reports can be shared in the Power BI service or embedded in other apps.
SQL Server Analysis Services· Related to · Product An analytical data engine that hosts semantic models for reports and analysis. It supports tabular and multidimensional models and data mining.
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.