SSIS had its day, but in the big leagues it can no longer play
SSIS pulls data from various locations (mostly SQL Server instances but also some flat files and SFTP), mainly for transforming the data …
Overview
What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Connect to traditional data sources (53)8.888%
- Simple transformations (53)8.585%
- Complex transformations (52)7.777%
- Testing and debugging (48)6.161%
Pricing
N/A
Unavailable
What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
26 people also want pricing
Alternatives Pricing
What is Clear Analytics?
Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
What is Vertify?
VertifyData is a cloud-based integration platform with core integration capacities, including a drag-and-drop interface and real-time synchronization. It also offers over 80 prebuilt connectors and templates, plus customizable integrations for scaling businesses.
Product Demos
Demonstration of Multicast transformation in SQL Server Integration Services (SSIS)
YouTube
SSIS Tutorial Part 78- What is Multicast Transformation in SSIS (Quick Demo)
YouTube
SSIS Tutorial Part 119-Execute SQL Task (Full Result Set) Demo in SSIS Package
YouTube
SSIS Tutorial Part 72- What is Conditional Split Transformation in SSIS (Quick Demo)
YouTube
SSIS Tutorial Part 02- How to Load Tab Delimited File To SQL Server Table in SSIS Package
YouTube
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is SSIS?
SSIS Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Reviewers rate Connect to traditional data sources highest, with a score of 8.8.
The most common users of SSIS are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(258)Attribute Ratings
Reviews
(26-50 of 53)Companies can't remove reviews or game the system. Here's why
In my work in the health care field, we use SQL Server Integration Services as our default ETL tool of choice for pulling data into SQL Server from Teradata, Oracle, flat file and other SQL Server databases, and for creating data extracts to send to our clients, typically in the form of flat files.
June 07, 2019
SSIS - Strong performer in the traditional data space, but can be improved in handling JSON objects
We implement data solutions for our clients. We use SSIS frequently as an ETL and Data Integration Tool for clients that have the Microsoft enterprise licensing as it offers decent base-level capabilities for traditional database management systems, and we can justify the tool selection since the technology cost-effective under MS licensing.
January 15, 2019
SQL Server Integration Services: a great tool for small to medium sized implementations
SSIS is used within my organization to move data from one data source to another, performing data translations, transformations, lookups and calculations during the data movement. This process often includes very complex data transformation processes including the use of APIs, external references and various class libraries. SSIS is currently used in various areas across the entire organization to solve SQL server-based data transformation issues.
December 07, 2018
SSIS for data integration and ETL!
We use SSIS to connect to API's and other DB stores/wh/marts, etc. In our projects, many different data sources and types exist, and we build BI from the disparate sources that exist within our larger clients. SSIS is used as tool to harvest those disparate sources and run jobs to populate our end DB which feeds our visualization tools.
July 16, 2018
SSIS is one of the best ETLs
SQL Server Integration Services is used for the following purposes in my organization.
1. Extract data from the source database and transform it and then load it into a destination database
2. Use this for Balancing between 2 or more different databases
3. Extract the data from relational databases and load into data ware house.
1. Extract data from the source database and transform it and then load it into a destination database
2. Use this for Balancing between 2 or more different databases
3. Extract the data from relational databases and load into data ware house.
June 21, 2018
Good integration with MSSQL
It is mainly used by technical analysts with the purpose of delivering data integration and reporting projects to customers. It addresses the need for complex multi-source data ingestion, data manipulation, and integration to a MSSQL database.
SSIS was being used as an ETL tool both by IT as well as business teams. It is now replaced by a competitor though. The tool was being used for basic extraction and loading purposes, with hardly any complex data transformation being done. Though there were use cases to exploit the tool, neither Microsoft nor in-house consultants really helped with the tool, with the result being it getting replaced.
April 06, 2018
A solid ETL tool. Data doesn't stay in one place, SSIS keeps it going where it needs to go.
Like most businesses, we have various sources of data that management likes to be able to compare to each other. I use SSIS primarily to move data between our source systems and data marts and warehouses that our reporting software can be pointed at. I also use SSIS to deliver scheduled file exports to external customers or to import files into one of our critical systems for use. I even tend to use it for non-SQL related things such as file system and ftp tasks. If it needs to be extracted, transformed, or loaded somewhere, I use SSIS to do it.
In the beginning, we had hundreds of Stored Procedures, instead of SSIS packages. The Stored Procedures were poorly made by some users, only thinking on the resulting query and not the execution performance, plus the people doing data mining created tables for a report and then they didn't eliminate such tables that only had one use, also some of those tables kept growing without being needed any longer.
The implementation and onboarding of SSIS was made with the intention to correct some of these T-SQL coding issues. It is easier to understand a diagram than sheets of T-SQL code with good documentation. Besides the performance for bulk inserts was better with SSIS than normal inserts in stored procedures. We were able to divide and define a bit better the roles, between SQL developers, Data miners, and BI engineers.
February 15, 2018
Great ETL tool
We currently use SSIS for imports of purchase orders into our ERP - SYSPRO. These purchase orders come in various file formats: EDI, XML and excel spreadsheets. SSIS helps us aggregate these various files into a common import platform and apply business logic such as ship date calculations, SKU availability checks, customer hold checks etc.
August 10, 2017
SSIS
I've used SSIS to support individual departments within an organization. Typically I use SSIS to automate migrating and transforming data from one location to another. SSIS has a diverse range of source and destination formats that makes it easy to move data between different systems. There are many add on tools for other source / destinations that are not out of the box. For example, Dynamics CRM.
July 19, 2017
SSIS offers what I need for data processing.
In my current organization, SSIS is being used by the enterprise data warehouse team. This team uses SSIS to construct data warehouse, prepare data cubes, and fulfill ad-hoc data-related acquisitions.
March 29, 2017
SSIS Addict
Integration Services is the primary extraction, transformation, and loading tool we use to populate our SQL Server and Azure SQL DB and DW for our data and our clients' data. We do a majority of our logic for preparing both reporting and application data within SSIS components, scripts, or within T-SQL Stored Procedures executed within SSIS Control flows. It is only used within my group but my group is the only group directly populating our reporting databases.
August 05, 2016
Use it if you have a Microsoft Stack
I cannot say for the whole organization, but we use SSIS for just about all our automation processes. When managing a large data warehouse it is incredibly useful to automate the ETL process. We primarily use it for the data warehouse, but it's versatile enough to use for other automation tasks, reports, and notifications.
July 15, 2016
SSIS fits perfectly in Microsoft environments
SSIS is our main ETL tool since we are mostly a SQL Server shop. We use it to integrate data into all of our reporting environments, transforming and massaging data dynamically and connecting to many various sources along the way. It is also a quick way to move data out of other Microsoft environments such as Excel and Access Database.
June 04, 2016
SSIS - Our go to ETL Tool
SQL Server Integration Services is the go to tool for our Data Integration team for automating a number of disparate data imports. We deal with a number of file sources (Excel, CSV, TXT, etc) that need data transformed for import into our SQL databases. SSIS allows us to handle any number of file formats and types efficiently, and we can perform all data validations necessary to ensure utmost data integrity.
June 03, 2016
SSIS- Mundane but Dependable
SSIS is utilized as a systems and data integration tool, and for performing a variety of ETL tasks. It is utilized by the IT department to support business applications, particularly where two or more systems require data exchange. It is a mature product (stable and reliable) and comes as part of standard SQL Server implementations so its fairly simple to utilize.
May 26, 2016
SSIS is terrific for all your ETL needs.
Our laboratory uses SSIS to transfer data between servers and databases, to data warehouses, reporting services and to and from file sources in a complex SQL Server environment that includes Merge Replication and SQL Server Reporting Services. Besides internal transfer, transformation, and manipulation of data, including archiving of data, we use SSIS to export laboratory results to external systems and import scheduling and sampling information from external systems.
May 23, 2016
SSIS is great if when used in the right place
Ee create master data management and workflow software for oil and gas companies which involves getting and writing data to other systems. We use SSIS for all integration as it helps dealing with different systems.
May 06, 2016
A Reliable Data Preparation Tool.
SSIS is used by the IT department for extracting, transforming, and loading data. The most common application for SSIS would be for cleansing and restructuring data while it is being loaded into a data warehouse.
April 28, 2016
SSIS - A great ETL solution!
SSIS is used by a lot of people within our technology department, but it is used heavily by our developers. We utilize this tool to move data between servers as an alternative to using a linked server and also to migrate data into our production systems from third party databases.
April 15, 2016
A high-performance ETL product
In our department we use SQL Server Integration Services daily. The main use is to do data processing for several ETL processes. Thanks to the use of SQL Server Integration Services we can upload data to the data warehouse in different ways such as a bulk load or with incremental loads thanks to the use of SCD task data.
February 23, 2016
SSIS is ETL's best buddy for skilled SQL Developers
SSIS is a powerful tool to perform various ETL-like functions between homogenous and heterogeneous sources of data. It was widely used in all organizations I worked since it provides an easy way to create data transformations.
October 30, 2015
The Review
It is been used in the entire department to support enterprise analytics and reporting
October 29, 2015
SSIS Cheap and easy to use
We use SQL Server Integration Services to pull data from FTP sites.