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
- Because SSIS comes "free" with SQL Server, there is no additional one-time or recurring software license fee to pay.
- SSIS has a fairly shallow learning curve so any Microsoft-oriented software development team can adopt it and put it into production service with very little training time needed.
- Packages created in SSIS can easily be transitioned from development to production use either via direct deployment to SQL Server or via a deployment management system.
June 07, 2019
SSIS - Strong performer in the traditional data space, but can be improved in handling JSON objects
- We have delivered numerous projects to our clients using SSIS where the client has been very happy with the delivery of our solution.
- The big struggle with SSIS is having multiple devs on a single SSIS package, this can create merge nightmares from a source control standpoint.
- Overall SSIS is a good option for clients who have Microsoft enterprise licensing. It provides a good set of capabilities for RDBMS systems, but you will need more custom dev if you are ingesting emerging feeds such as JSON objects.
January 15, 2019
SQL Server Integration Services: a great tool for small to medium sized implementations
- SQL Server Integration Services has had a positive impact on our organization as it has allowed us to integrate data from external data sources via CSV and flat files
- SQL Server Integration Services has a waning positive impact on our organization as we are moving more toward Big Data and Oracle data
- Given the initial investment in SQL Server Integration Services, the ROI has been positive as it has enabled business-critical ETL for the past 5 years
December 07, 2018
SSIS for data integration and ETL!
- Quick and easy tool to bring disparate data together to make final harvest a 1 stop shop for data visualization
- No need to pay elaborate hourly rates for Python scripts etc if you don't need to harvest data that way.
July 16, 2018
SSIS is one of the best ETLs
- Positive Impact: Faster Performance
- Negative Impact: Script Task and Script component always hangs up
June 21, 2018
Good integration with MSSQL
- As it is part of the SQL related products, customers are more receptive to the product due to the lower risk. This increased our product offerings in our solutions for projects.
- The work required to implement an SSIS project is relatively quick compared to other tools and it reduces the amount of time required by staff to configure.
- It wasn't used effectively, resulting in not realising ROI to the extent we had anticipated
- It was easy to learn, which resulted in business teams using it extensively without IT support, resulting in lots of packages/code to maintain
April 06, 2018
A solid ETL tool. Data doesn't stay in one place, SSIS keeps it going where it needs to go.
- I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
- It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.
- It comes with SQL server, so if you are already using that for the DB, we had no charge for using SSIS for the same solution. That is one big advantage of Microsoft, they provide the whole combo for BI at once.
- ROI is a time measure, if you bought SQL just for the DB, but then you want to use SSIS, most probably it is already there.
- If you try even an open source solution, you will have to install it and get trained on it, for SSIS the learning curve is very short.
- Be careful, SSIS is for ETL, not for middleware at an enterprise level. In the begining it might work but it is not the purpose of the tool, for middleware solutions where the business depends on, don't get confused and if you are still looking for Microsoft go for BizTalk.
February 15, 2018
Great ETL tool
- Saves us a considerable amount of time required to import our data.
- Streamlines the order import/processing process for our business and makes it easier for us to meet our target ship dates as we have no bottlenecks during the import flow.
August 10, 2017
SSIS
- SSIS can have significant ROI by automating data flow processes and putting data integrity checks and transformations in place during the process. The reliability of the process increases and time is recouped because no end user is responsible.
- Ability for non programmers to create and automate processes.
July 19, 2017
SSIS offers what I need for data processing.
- Various data requests have been fulfilled without much hazard using SSIS (data processing, ETL job, schedules, etc.)
- Data related standards have been enforced on SSIS development methodology so that data quality has been improved.
- Advanced features have been implemented using SSIS (e.g. FTP file notification) to automate some of the manual work.
March 29, 2017
SSIS Addict
- Investment in SS/SSIS was already done before I joined. But we could not operate without SSIS at this point. So much implementation has done within SSIS that migration would be next to impossible at this point.
August 05, 2016
Use it if you have a Microsoft Stack
- Using SSIS has allowed us to free up a lot of time from our business users. We do a lot of predictive analytics here and we generate models/reports for various business units outside of our own. This involves ETL, running stored procedures, executing R scripts, and running other analytical tools over the data and generating data. By automating a lot of these tasks, these users are free to do more research and explore other opportunities for revenue/profit.
- SSIS is a pretty popular tool and it is not difficult to hire users that have experience. We don't need to spend a lot of time training new associates no how to use the product which saves us a lot of resources.
- Overall, we're able to achieve our business goals because it does what it's intended to do. We're able to integrate our tools and applications together to create new products and revenue streams.
July 15, 2016
SSIS fits perfectly in Microsoft environments
- Faster implementations
- Integrated reporting environments
- Cost savings via automation
June 04, 2016
SSIS - Our go to ETL Tool
- SSIS has been a huge time savings where previously manual data scrubbing and/or import tasks have been automated.
- It has allowed us to schedule jobs that previously required human involvement. Now everything runs seamlessly through SQL jobs.
- It provides us with a wider customer base as we are pigeon-holed into working with a small number of data source options. We can work with an infinite amount of data sources due to our utilization of SSIS.
June 03, 2016
SSIS- Mundane but Dependable
- SSIS comes with standard SQL Server implementations, so it does not cost extra to utilize. On the other hand, its inflexibility makes it inferior to some other leading ETL tools. Investments into tools other than SSIS must be weighed against the pricing model for shops already using SQL Server.
May 26, 2016
SSIS is terrific for all your ETL needs.
- SSIS has allowed us to meet a complex variety of ETL needs without having to acquire a profound knowledge of application programming and the learning curve is really not bad considering the power available. We heavily depend on SSIS every day.
- SSIS or SQL Server doesn't play nice with Sybase databases, and it takes some work to make ETL go smoothly between Sybase and SQL server databases, particularly since SQL Server Management Studio can't query certain Sybase formats.
- It is included with SQL Server, so it is a very powerful tool included at no additional cost. It has saved us a lot of money over possible alternatives.
May 23, 2016
SSIS is great if when used in the right place
- Comes free with SQL server so no additional license
- Easy to learn and material is available for free, no need for expensive training
May 06, 2016
A Reliable Data Preparation Tool.
- Data preparation is the majority of the effort involved in data warehousing projects. The amount of time it takes to prepare data is the same now as it was when the product was introduced in 2005. There are more features now, but the amount of time that you are spending with the tool has still remained the same.
- SSIS is a very widely used tool, making talent easy to find.
- Because its included with SQL Server, you don't have to go through any additional effort to purchase this tool. If you own SQL Sever then you already own SSIS.
April 28, 2016
SSIS - A great ETL solution!
- Earlier this year, our company moved away from Microsoft Dynamics CRM and developed our own CRM system. SSIS was heavily utilized when we migrated data from Microsoft Dynamics CRM to our new system.
- SSIS also helped us save hundreds of thousands of dollars. We had primarily used a third party ETL tool to migrate data from third party systems into our customized version of Microsoft Dynamics. When looking into vendors that could potentially build a new tool for us to migrate into the new system, we found out quickly it wasn't going to be cheap (because those companies could not sell the adapters they would build to outside companies, since it was for a proprietary system). SSIS, along with procedures/tools we built in house, allowed us to develop and execute these tools in house.
- It's allowed us to streamline many things (backup exports, data migration, etc.).
April 15, 2016
A high-performance ETL product
- SSIS is integrated into SQL Server licenses
- Once developed your packages are very stable and it requires relatively little maintenance
- If used wisely, it saves a lot of working time
February 23, 2016
SSIS is ETL's best buddy for skilled SQL Developers
- SSIS provided good value for the money
- SSIS comes as a feature of SQL Server Standard/Enterprise etc. editions so we don't have to spend extra money for other ETL tools
October 30, 2015
The Review
- Positive impact is that it is easier to train you employees and it is easy to learn
- Negative impact is, in a time sensitive environment it may fall, so the improvement it needs is to hold large data efficiently
October 29, 2015
SSIS Cheap and easy to use
- Automation leading to cost savings due to less headcount
- Eliminate redundancy
- Better customer service