M365Con 2027 – conferencia online gratuita · 11–22 Jan 2027 · 120 sessions→ m365con.net

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.

◆ PRODUCTOSQL Server IntegrationServicesM365.FM
Gráfico de título: SQL Server Integration Services (Producto)

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.

TipoProducto
También conocido comoSSIS, Integration Services
Sitio weblearn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17
Documentaciónlearn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver17
SQL ServerIntegration…MicrosoftDeveloped byAnalytics and BI to…Is aDeveloper toolIs aMicrosoft SQL ServerRelated toSQL Server AgentRelated toAzure Data FactoryRelated toMicrosoft FabricRelated toPower BIRelated to
Mapa de relaciones de SQL Server Integration Services: temas enlazados

Developed by

Is a

Related to

Glosario

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: