SSIS
SQL Server Integration Services
Overview
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
View all 12 features- Simple transformations (57)8.888%
- Connect to traditional data sources (57)8.787%
- Complex transformations (56)7.878%
- Testing and debugging (52)6.969%
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SSIS, and make your voice heard!
Pricing
View all pricingEntry-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?
8 people want pricing too
Alternatives Pricing
Features Scorecard
Data Source Connection
7.6
76%
Data Transformations
8.3
83%
Data Modeling
7.8
78%
Data Governance
7.4
74%
Product Details
What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
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 Simple transformations highest, with a score of 8.8.
The most common users of SSIS are from Enterprises (1,001+ employees) and the Information Technology & Services industry.
Comparisons
View all alternativesCompare with
Reviews and Ratings
(257)
Reviews
(1-25 of 57)- Popular Filters
Companies can't remove reviews or game the system. Here's why
- There has been positive Return on Investment since we deployed this system.
- The set business plans have been achieved.
- SSIS provided good value when there were few competitors, for somebody already using SQL Server Enterprise Edition.
June 28, 2022
SSIS, the must have extension for SSMS
- Reduce data migration task to half of time.
- Additional investment to integrate with other company tools.
June 25, 2022
Data Solutions at its Best!!
- Worth the Money spent.
- Some time becomes tedious due to clicks.
- Have made data extraction a breeze.
- Rapid integration with source systems has provided a high ROI however this is based on using BIML in conjunction with SSIS.
- Combination of workflow, data manipulation and scripting make it a very capable data integration tool.
June 25, 2022
One of the best on-premise ETL tools
- Negative impact - We still need plugins like CozyRoc for basic things like connecting to SFTP. This slows development
- Positive impact - We don't need to pay extra for this. It comes with SQL Server license.
June 24, 2022
Amazing data warehousing tool
- We can easily merge data on a variety of databases.
- Loading and migrating data is fast.
- It offers a simple system for analyzing raw data.
- We appreciate how much time it has saved our IT department by generating reports on their systems' compliance.
- Maintaining consistent data across all of an organization's products helps streamline operations and cut down on wasted time and money.
- By consolidating our data automatically, we can improve our input planning and cut down on wasteful overbuying and stockpiling.
June 24, 2022
Good for startups or companies with limited data variability, Big data companies will need better tools
- Good ROI for companies using the MS suite of tools (SQL Server / SSDT) without having to purchase additional tools.
- SQL Server is expensive, so running very complex processes using SSIS will become quickly very expensive.
- Able to managed very dense healthcare data in this software.
- Creation of data models and automated scripts.
- SQL Server Integration has helped in data management by cutting down on collaboration times.
- SQL Server Integration has helped in data query & complex data modeling very effectively.
- SQL Server Integration has helped in designing better workflows.
June 24, 2022
Tool for data integration and migration
- More cost-efficient than other ETL tools of the same stature
- No extra requirement of learning anything other than SQL itself
- Helps in analysing customers' data by collecting them at a single place
June 23, 2022
SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
- Faster loading of new data (imports).
- Very effective data cleansing or transformation of dirty data.
- Managing critical DBA tasks like purging old files or indexing a database.
June 23, 2022
Worth of money
- Clear sense of data
- Data modeling
- Multiple Data resource handling
June 23, 2022
SQL Server Integration Services Review
- We are on a Data Migration project of huge scale from Legacy to Cloud. So it does help a great deal to us and definitely gives us better ROI.
- The data model, analysis with this will helps us to have better product portfolio's and for research purpose as well on business.
- Not much negative to point out though it can be improved on Big data ETL and some UI.
June 23, 2022
Data processing with SSIS
- Helped to increase revenue for the clients
- Saved big time and work
- Increased productivity
June 23, 2022
SSIS, free but not intuitive
- Without this, we would have to manually update a spreadsheet of our SQL Server inventory
- We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
- We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
December 08, 2021
Provides value to cost and excellent with MSBI Stack, But needs more features/updates
- Faster loads.
- Cheaper alternative but more development & compromise on performance.
- Support with cloud tech other than Microsoft.
- Saved our IT organization time by making reports of their their systems compliance.
May 01, 2021
SQL Server Express + SSIS basics
- Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
- Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
- The employee number, responsible for data management was reduced from 4 to 1 person
- Being able to automate data integration across systems has always been a great source of savings, so the ROI is there.
- The nice thing about SSIS is that it can continue to grow, so a project this year provides and ROI for every year going forward, and frees up time to implement additional integration opportunities further increasing ROI.
- It allows for easier automation
February 17, 2020
SSIS Just Works
- Consolidation into a standard tool for data movement makes maintenance and administration easier.
- The extensibility of the tool has allowed us to fill the gaps with 3rd party add-ons.
January 19, 2020
Great Tool For ETL Design
- Paying a license fee to the SSIS ETL vehicle for our enterprise projects increases our costs.
- Because it is a powerful and performance ETL tool, data increases our business productivity.
November 24, 2019
Our use of SSIS
- Positive - easier to manage and maintain data imports and maintain consistency over time.
- Positive - reusable projects reduces time for repetitive tasks.
- Negative - learning curve. Variety and flexibility of possible solutions can be overwhelming.