SQL Server Integration Services
Producto
Microsoft's platform for data integration and ETL. It moves, cleans and transforms data with packages that run on SQL Server or in Azure.
Descripción
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.
| Tipo | Producto |
|---|---|
| También conocido como | SSIS, Integration Services |
| Sitio web | learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17 |
| Documentación | learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17 |
Developed by
- Microsoft · Organización
Is a
- Analytics and BI tool · Categoría
- Developer tool · Categoría
Related to
- Microsoft SQL Server · Producto
- SQL Server Agent · Producto
- Azure Data Factory · Producto
- Microsoft Fabric · Plataforma
- Power BI · Producto
- SQL Server Analysis Services · Producto
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Expertos y empresas para este tema
Nadie ha indicado aún este tema. Añádelo a tu perfil.
Fuentes
Mantenido por Mirko Peters (Microsoft MVP) · Última actualización: