Skip to main content
TrustRadius
SSIS

SSIS

Overview

What is SSIS?

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.

Read more

Learn from top reviewers

SSIS had its day, but in the big leagues it can no longer play

Rating: 5 out of 10
June 29, 2022
IncentivizedVetted ReviewVerified User
SSIS pulls data from various locations (mostly SQL Server instances but also some flat files and SFTP), mainly for transforming the data and putting it in the data warehouse.
Continue reading
Alex Bransky
Engineer - Engineering
Principal Data Engineer
Ad Hoc LLC
SQL Server Integration Services17 years of experience

Amazing data warehousing tool

Rating: 8 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
We are currently using SQL Server as our central relational database. Getting data from multiple sources to our data depository is smooth. We use SQL Server Integration Servic...
Continue reading
Robbie Scott
Consultant - Information Technology
Security Software Engineer
Tata Consultancy Services
SQL Server Integration Services4 years of experience

Good for startups or companies with limited data variability, Big data companies will need better tools

Rating: 8 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
SQL Server is the legacy Database and Data Warehouse in the company. SSIS is used for most ETLs where the data is sourced from / put into SQL Server, depending on the use case...
Continue reading
Vishal Shah
Engineer - Product Management
Data Engineer, Product Analytics
Carvana
SQL Server Integration Services3 years of experience

Data integration and migration are made easier with this tool.

Rating: 9 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
A good tool for SQL server query and data migration. The way it stores data and makes it easier for the user to write queries over the server. Compatibility with different BI ...
Continue reading
Shubham Rawat
Employee - Research & Development
Data Analyst
DayToDay Health
SQL Server Integration Services2 years of experience

SSIS, free but not intuitive

Rating: 6 out of 10
June 23, 2022
IncentivizedVetted ReviewVerified User
SQL Server Integration Services is an extremely powerful tool that we're using exclusively for SQL Server inventory and other jobs. While it is very powerful, it's also not ex...
Continue reading
Sean Ford
Professional - Information Technology
Database Engineer
Shelter Insurance
SQL Server Integration Services3 years of experience
Log in with LinkedIn to see content from your network

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

Return to navigation

Pricing

View all pricing
SSIS

SSIS

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?

27 people also want pricing

Alternatives Pricing

Clear Analytics

Clear Analytics

$29
Per Seat per Month
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.

Vertify

Vertify

$7,350
per year
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.

Return to navigation

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
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.5
Avg 8.4

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

8.1
Avg 8.2

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.4
Avg 7.9

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

6.9
Avg 8.2
Return to navigation

Product Details

What is SSIS?

SSIS Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

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).
Return to navigation

Comparisons

View all alternatives

Compare with

dbt

dbt

Compare
Microsoft Power BI

Microsoft Power BI

Compare
Apache Spark

Apache Spark

Compare
Snowflake

Snowflake

Compare
IBM DataStage

IBM DataStage

Compare
Microsoft Power Automate

Microsoft Power Automate

Compare
Talend Data Integration

Talend Data Integration

Compare
Apache Kafka

Apache Kafka

Compare
KNIME Analytics Platform

KNIME Analytics Platform

Compare
Alteryx Platform

Alteryx Platform

Compare
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 53)

Good for startups or companies with limited data variability, Big data companies will need better tools

Rating: 8 out of 10
Incentivized
June 24, 2022
VS
Vishal Shah
Data Engineer, Product Analytics
Carvana (Automotive, 5001-10,000 employees)
Vetted Review
Verified User
SQL Server Integration Services
3 years of experience
View profile
Pros
  • Standard ETL use cases for daily loads
  • Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
  • Creating outgoing data files and writing them to Vendor FTPs
  • Easy Active Directory integration for seamless connections to SQL Server
  • CI/CD by hosting the code on visualstudio.com
Cons
  • API connections are not a native functionality. We use Zappysys extensions but they work only in certain cases.
  • Dependency executions - no simple way to create a hierarchy/chain of executions. Ex: Define if the execution of the child process should be stopped if a parent fails or a certain condition is triggered in the parent process and then redirect to a different part of the chain (think like a flowchart for executions).

SSIS, free but not intuitive

Rating: 6 out of 10
Incentivized
June 23, 2022
SF
Sean Ford
Database Engineer
Shelter Insurance (Insurance, 1001-5000 employees)
Vetted Review
Verified User
SQL Server Integration Services
3 years of experience
Pros
  • Runs flawlessly after setup properly
  • Powerful, as mentioned
  • Free
Cons
  • Confusing operation, even with its gui
  • Requires special install and setup
  • Requires the Visual studio integration services install (separate interface from SSMS)
  • Could be more easily integrated into SSMS, but may also be used for other products that I'm not aware of

SSIS had its day, but in the big leagues it can no longer play

Rating: 5 out of 10
Incentivized
June 29, 2022
AB
Alex Bransky
Principal Data Engineer
Ad Hoc LLC (Information Technology & Services, 201-500 employees)
Vetted Review
Verified User
SQL Server Integration Services
17 years of experience
View profile
Pros
  • SSIS is good for small, simple data syncs.
  • SSIS is good for moving data quickly into SQL Server (good batch performance).
Cons
  • Very hard to diff for code review when changes are made.
  • Very buggy IDE (freezes in Visual Studio, doesn't always show what's in the underlying XML properly)
  • Lacking lots of features or more modern tools, like ability to monitor for changes to the source schema and apply them to the target.

Amazing data warehousing tool

Rating: 8 out of 10
Incentivized
June 24, 2022
RS
Robbie Scott
Security Software Engineer
Tata Consultancy Services (Information Technology & Services, 10,001+ employees)
Vetted Review
Verified User
SQL Server Integration Services
4 years of experience
View profile
Pros
  • I am able to use the GIS tools to easily generate solutions without coding.
  • Built in tasks that speed up web developing.
  • SSIS enables automated data preparations.
  • Amazing integration with Microsoft tools.
  • Creation of ETL mapping.
Cons
  • It depends so much on the Microsoft environment and has integration issues with other formats like JSON and Excel.
  • Error messages are unclear, this makes us spend a lot of time figuring out what has gone wrong making the debugging process hectic.

Data integration and migration are made easier with this tool.

Rating: 9 out of 10
Incentivized
June 24, 2022
SR
Shubham Rawat
Data Analyst
DayToDay Health (Hospital & Health Care, 201-500 employees)
Vetted Review
Verified User
SQL Server Integration Services
2 years of experience
View profile
Pros
  • Assists in connecting to several data sources and loading the resulting data.
  • Less expensive than other ETL tools of same stature.
  • Does away with the requirement for coding scripts.
Cons
  • There isn't a lot of room for building user-required automation.
  • Some activities need manual labour, such as exporting multiple tables in CSV format one at a time.
Return to navigation