SQL Server Integration Services

E56984
ETL tool Microsoft software product data integration platform

SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (5)

Label Occurrences
SQL Server Integration Services canonical 13
DTS Designer 1
SQL Server Integration Services DQS components 1

Statements (79)

Predicate Object
instanceOf ETL tool ⓘ
Microsoft software product ⓘ
data integration platform ⓘ
abbreviation SQL Server Integration Services self-linksurface differs ⓘ
surface form: SSIS
developer Microsoft ⓘ
hasComponent Control Flow ⓘ
Data Flow ⓘ
Event Handlers ⓘ
Integration Services service ⓘ
Package Explorer ⓘ
SSIS Catalog ⓘ
SQL Server Integration Services self-linksurface differs ⓘ
surface form: SSIS pipeline engine

SSIS runtime engine ⓘ
SSISDB database ⓘ
includedWith SQL Server ⓘ
surface form: SQL Server Enterprise Edition

Standard Edition ⓘ
surface form: SQL Server Standard Edition
introducedIn SQL Server ⓘ
surface form: SQL Server 2005
licenseModel proprietary ⓘ
partOf SQL Server ⓘ
surface form: Microsoft SQL Server
primaryLanguage C# (for Script Task and Script Component) ⓘ
VB.NET (for Script Task and Script Component) ⓘ
replaced Data Transformation Services ⓘ
runsOn Windows ⓘ
supportsDeployment Azure Data Factory ⓘ
surface form: Azure-SSIS Integration Runtime in Azure Data Factory

on-premises SQL Server ⓘ
supportsDestination ADO.NET destinations ⓘ
Excel files ⓘ
ODBC destinations ⓘ
OLE DB destinations ⓘ
SQL Server Analysis Services ⓘ
SQL Server ⓘ
surface form: SQL Server relational databases

flat files ⓘ
raw files ⓘ
supportsFunction bulk data loading ⓘ
change data capture integration ⓘ
checkpoint restartability ⓘ
control flow management ⓘ
data cleansing ⓘ
data encryption in transit ⓘ
data flow transformations ⓘ
data integration ⓘ
data migration ⓘ
data profiling ⓘ
data warehousing ETL ⓘ
deployment to SSIS Catalog ⓘ
environment-specific configurations ⓘ
error handling and logging ⓘ
event handling ⓘ
extract data ⓘ
file system operations ⓘ
incremental data loading ⓘ
load data ⓘ
logging to multiple targets ⓘ
lookup operations ⓘ
message queue integration ⓘ
package configuration ⓘ
package deployment model ⓘ
parallel task execution ⓘ
parameterized execution ⓘ
project deployment model ⓘ
scheduling via SQL Server Agent ⓘ
script-based transformations ⓘ
slowly changing dimension handling ⓘ
transform data ⓘ
versioning of packages in catalog ⓘ
workflow orchestration ⓘ
supportsSecurityFeature SQL Server Authentication ⓘ
NTLM ⓘ
surface form: Windows Authentication

credential-based connections ⓘ
package protection levels ⓘ
supportsSource ADO.NET data sources ⓘ
Excel files ⓘ
ODBC data sources ⓘ
OLE DB data sources ⓘ
SQL Server relational databases ⓘ
XML files ⓘ
flat files ⓘ
usesIDE SQL Server Data Tools ⓘ
Visual Studio ⓘ
surface form: Visual Studio (via SSDT)

Referenced by (17)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server → hasComponent → SQL Server Integration Services ⓘ
Data Quality Services → integratesWith → SQL Server Integration Services ⓘ
Master Data Services → integratesWith → SQL Server Integration Services ⓘ
Developer Edition → supports → SQL Server Integration Services ⓘ
SQL Server Integration Services → abbreviation → SQL Server Integration Services self-linksurface differs ⓘ
this entity surface form: SSIS
SQL Server Integration Services → hasComponent → SQL Server Integration Services self-linksurface differs ⓘ
this entity surface form: SSIS pipeline engine
Microsoft BI stack → hasComponent → SQL Server Integration Services ⓘ
SQL Server Management Data Warehouse → uses → SQL Server Integration Services ⓘ
DQS Server → supportsIntegrationWith → SQL Server Integration Services ⓘ
DQS Client → relatedTo → SQL Server Integration Services ⓘ
DQS_MAIN → accessedBy → SQL Server Integration Services ⓘ
this entity surface form: SQL Server Integration Services DQS components
SQL Server Analysis Services → integratesWith → SQL Server Integration Services ⓘ
SQL Server on Azure Virtual Machines → supportsFeature → SQL Server Integration Services ⓘ
Business Intelligence Development Studio → supports → SQL Server Integration Services ⓘ
Data Transformation Services → hasComponent → SQL Server Integration Services ⓘ
this entity surface form: DTS Designer
Data Transformation Services → replacedBy → SQL Server Integration Services ⓘ
Extended Events → supportsProduct → SQL Server Integration Services ⓘ