- Home
- ETL Software
- SQL Server Integration Services
On the recordRead 7 Oct 202624 facts
SQL Server Integration Services
On the record
- Azure connections
- The Azure Feature Pack lets SSIS packages connect to Azure Blob Storage, Azure HDInsight, Azure Data Lake Store, Azure Synapse Analytics, and Azure Data Lake Storage Gen2.learn.microsoft.com · read 7 Oct 2026
- Azure execution
- An Azure-SSIS integration runtime in Azure Data Factory or Azure Synapse Pipelines can run packages deployed to SSISDB, file system, Azure Files, or SQL Server MSDB on Azure SQL Managed Instance.learn.microsoft.com · read 7 Oct 2026
- Connections
- Packages can connect to data stores including text, XML, and Excel files and relational databases for extracting, loading, lookups, SQL statements, and maintenance tasks.learn.microsoft.com · read 7 Oct 2026
- Data movement
- SSIS extracts and transforms data from sources such as XML files, flat files, and relational data sources, then loads it into one or more destinations.learn.microsoft.com · read 7 Oct 2026
- Data transformations
- Built-in transformations can aggregate, merge, distribute, modify, sort, sample, and look up data, among other operations.learn.microsoft.com · read 7 Oct 2026
- Deployment
- SSIS deployment tools can move packages to another computer and manage dependencies such as configurations and files.learn.microsoft.com · read 7 Oct 2026
- Design tooling
- SSIS Designer is available in SQL Server Data Tools as part of an Integration Services project; SSDT and the appropriate extension are used to design and deploy packages.learn.microsoft.com · read 7 Oct 2026
- Development and management
- SQL Server Data Tools is used to develop packages, while SQL Server Management Studio is used to manage packages in production.learn.microsoft.com · read 7 Oct 2026
- Edition limits
- The feature matrix lists built-in connectors, tasks, transformations, ODBC, Azure, Hadoop/HDFS, and basic profiling for Enterprise and Standard editions, while several advanced sources and transformations are Enterprise-only.learn.microsoft.com · read 7 Oct 2026
- ETL
- SSIS extracts and transforms data from sources such as XML files, flat files, and relational data sources, then loads it into one or more destinations.learn.microsoft.com · read 7 Oct 2026
- Extensibility
- Developers can create packages programmatically and write custom tasks and other package objects.learn.microsoft.com · read 7 Oct 2026
- Linux support
- Microsoft's feature matrix lists Linux support for Enterprise, Standard, and Express editions, and notes that DTSWizard.exe is not provided with SQL on Linux.learn.microsoft.com · read 7 Oct 2026
- Notable limit
- SSIS is not included with SQL Server Express, and installing SSIS alone does not install the tools needed to design and develop packages.learn.microsoft.com · read 7 Oct 2026
- Other connectors
- The installation guidance lists optional Microsoft connectors for Oracle, Teradata, and SAP BW.learn.microsoft.com · read 7 Oct 2026
- Package design
- It includes graphical tools, built-in tasks and transformations, and an SSIS Catalog database for storing, running, and managing packages.learn.microsoft.com · read 7 Oct 2026
- Package management
- The SSIS Catalog database stores, runs, and manages packages; the SSISDB catalog can store, manage, run, and monitor them.learn.microsoft.com · read 7 Oct 2026
- Package security
- Package protection levels can protect sensitive data or the whole package using a password, user key, or server storage; password-based protection uses AES with a 256-bit key.learn.microsoft.com · read 7 Oct 2026
- Platform and installation
- SSIS is installed through SQL Server Setup on a computer, either by itself or alongside other SQL Server components.learn.microsoft.com · read 7 Oct 2026
