SQL Server Integration Services vs. SSIS Data Flow Components

SQL Server Integration Services

259 Reviews and Ratings

SSIS Data Flow Components

5 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
SSIS	Score6.5 out of 10	N/A	Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.	N/A
SSIS Data Flow Components	Score8.1 out of 10	N/A	Devart SSIS Data Flow Components are designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages, allowing users to connect cloud applications and databases through their SSIS workflows without the need to write complex code. Export data from various sources to different file formats Import XML, CSV, and other files to cloud applications and databases Synchronize cloud applications and databases Migrate from one…	$549.95 one-time fee

Pricing

SSIS

SSIS Data Flow Components

No answers on this topic

SSIS Integration Database Bundle: $549.95
one-time fee
SSIS Integration Cloud Bundle: $749.95
one-time fee
SSIS Integration Universal Bundle: $999.95
one-time fee

Pricing Offerings
SSIS	SSIS Data Flow Components
Free Trial
No	Yes
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

No setup fee

No setup fee

—

Purchase includes a perpetual product license and a 1 year of subscription which includes the product updates and premium support.

Community Pulse
Key User Insights
	SSIS	SSIS Data Flow Components
Considered Both Products	Microsoft Jose Pla Systems/Software Engineer V in Engineering at Hewlett Packard Enterprise (Computer Hardware, 10,001+ employees) Chose SSIS Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS. Although I did … Incentivized Helpful? Verified User Chose SSIS SSIS works great with the above tools. We are a Microsoft shop so anything that fosters better integration among the various tools and platforms we use is very welcomed. Incentivized Helpful? Verified User Chose SSIS I have not used any other data transformation tools other than writing custom .exe programs. SSIS is far superior as it provides so much functionality out of the box. From data sources, transformations, error handling, parallelism, scheduling, etc. Incentivized Helpful? David Milillo Director Of Development in Information Technology at i.Predictus (Marketing and Advertising, 51-200 employees) Chose SSIS I've used several solutions from just simple ETL processes of stored procedures run manually to using Informatica. SSIS is a good in between solution. It has sufficient maturity to be preferable to scheduled procs in SS agent jobs. But does not have the sophistication and … Incentivized Helpful? Hung Nguyen Technical Analyst BI II (Global Business Intelligence and Analytics - Data Infrastructure) in Information Technology at Ingram Micro (Information Technology and Services, 10,001+ employees) Chose SSIS I've used several other ETL tools and they can all do the trick once you learn how to get around their shortfalls, including SSIS. I think the best reason to use SSIS is if you're already using Microsoft tools. They integrate well with each other and it's easy to understand how … Incentivized Helpful? Samir Patel, PMP SQL Development Team Lead in Information Technology at Allianz Asset Management (Investment Management, 1001-5000 employees) Chose SSIS SQL Server Integration Services is simpler to use and implement than Oracle Data Integrator. When it comes to resolving issues and getting community help SSIS is far superior. ODI has more complex functionality but would require more expert level staff for maintaining and … Incentivized Helpful? Eugene LaRoche .NET Team Lead in Information Technology at Mitsui Sumitomo Insurance Group (Insurance, 201-500 employees) Chose SSIS SSIS has these advantages: simple integration with MS technologies including Access, Excel, SQL RDBMS, Job Scheduler, and is included with SQL Server. Talend has these advantages: much quicker development time, 800+ built in components which provides off the shelf integration … Incentivized Helpful? Chris Morgan Chemist, LIMS Specialist in Information Technology at USDA-FSIS (Government Administration, 5001-10,000 employees) Chose SSIS If you are in a SQL Server environment, I really don't know why you wouldn't use SSIS since it is free with SQL Server and I don't know of any standalone tool that can match it. Redgate makes some great addon tools for SQL server that integrate with it to make it more powerful, … Incentivized Helpful? Verified User Chose SSIS We utilize a Microsoft SQL Server backend, because of SSIS's integration with MSSQL, it was a no brainer for us! Incentivized Helpful? Luca Campanelli Database Administrator in Information Technology at Intralot Italia S.p.A. (Gambling & Casinos, 51-200 employees) Chose SSIS Among the various ETL products on the market, I only used DataStage. I think that SQL Server Integration Services is much more intuitive than many others and allows for relatively little time to create a viable and very powerful solution. That obviously requires the right … Incentivized Helpful? Elena Goryainova DBA in Information Technology at Florida Family Insurance (Insurance, 51-200 employees) Chose SSIS I have used Informatica in the past and it doesn't really makes it easy for ETL. If you have some experience with SSIS, you can easily implement the same within SSIS and save money as Informatica license is much more expensive than the time spent for the development of custom … Incentivized Helpful? Shrikanth Mahale Senior Portfolio Analyst in Information Technology at Caliber Home Loans (Financial Services, 1001-5000 employees) Chose SSIS SSIS is compatible with windows and easy to use. Installation cost and maintenance cost is less. Incentivized Helpful? Verified User Chose SSIS SQL Server Integration Services is a very easy to learn, cost effective and efficient tool. Incentivized Helpful?	Devart No answer on this topic
	Would buy again
	No answers on this topic	No answers on this topic
	Delivers good value for the price
	No answers on this topic	No answers on this topic
	Happy with the feature set
	No answers on this topic	No answers on this topic
	Lived up to sales and marketing promises
	No answers on this topic	No answers on this topic
	Implementation went as expected
No answers on this topic	No answers on this topic

Features

SSIS

SSIS Data Flow Components

Comparison of Data Source Connection features of SQL Server Integration Services and SSIS Data Flow Components
Feature	SQL Server Integration Services 7.5 53 Ratings	SSIS Data Flow Components - Ratings
Connect to traditional data sources	8.853 Ratings	00 Ratings
Connecto to Big Data and NoSQL	6.240 Ratings	00 Ratings

Comparison of Data Transformations features of SQL Server Integration Services and SSIS Data Flow Components
Feature	SQL Server Integration Services 8.1 53 Ratings	SSIS Data Flow Components - Ratings
Simple transformations	8.553 Ratings	00 Ratings
Complex transformations	7.752 Ratings	00 Ratings

Comparison of Data Modeling features of SQL Server Integration Services and SSIS Data Flow Components
Feature	SQL Server Integration Services 7.4 51 Ratings	SSIS Data Flow Components - Ratings
Data model creation	8.627 Ratings	00 Ratings
Metadata management	7.133 Ratings	00 Ratings
Business rules and workflow	8.242 Ratings	00 Ratings
Collaboration	7.338 Ratings	00 Ratings
Testing and debugging	6.148 Ratings	00 Ratings

Comparison of Data Governance features of SQL Server Integration Services and SSIS Data Flow Components
Feature	SQL Server Integration Services 6.9 41 Ratings	SSIS Data Flow Components - Ratings
Integration with data quality tools	7.436 Ratings	00 Ratings
Integration with MDM tools	6.436 Ratings	00 Ratings

User Ratings
	SSIS	SSIS Data Flow Components
Likelihood to Recommend	8.0 (53 ratings)	- (0 ratings)
Likelihood to Renew	10.0 (3 ratings)	- (0 ratings)
Usability	9.3 (8 ratings)	- (0 ratings)
Performance	8.8 (6 ratings)	- (0 ratings)
Support Rating	8.2 (7 ratings)	- (0 ratings)
Implementation Rating	10.0 (1 ratings)	- (0 ratings)