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 8.0

Data Governance

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

6.9
Avg 8.3
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 Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 26)

Great ETL tool

Rating: 8 out of 10
Incentivized
February 15, 2018
Verified User
Professional in Information Technology
Sporting Goods Company, 201-500 employees
Vetted Review
Verified User
SQL Server Integration Services
12 years of experience
Use Cases and Deployment Scope
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.
Pros
  • Great for parsing data from various file formats into SQL server. As an example, we use it to extract data from XML, EDI and other flat files.
  • Great for applying custom business logic in the ETL process. These business logic could be built into functions, stored procedures and applied through the SSIS packages.
  • I like it's exception handling capabilities and how it's able to show the module that threw up the exception by highlighting it in red.
  • Works very well with Visual Studio and as a matter of fact, you can build all your SSIS packages right from SQL without even opening up SQL server or BIDS.
Cons
  • Not sure if it has JSON support but if it does, that would be awesome! Basically, the ability to consume data from a JSON data set.
  • In as much as Microsoft built it for the SQL database, it would be awesome if we could leverage SSIS for data ETL into other databases like MySQL and Oracle etc.
  • Add more color themes! The default color theme is old school and really sucks if you ask me.
Likelihood to Recommend
1. Great for ETL (Extract-Transform-Load) data operations.
2. Amazing if your primary database environment is SQL server.
3. Works great with Visual Studio and Microsoft even has it now on the Azure platform.
4. Works great with various file formats - XML, EDI, spreadsheets, flat files etc.
5. Works great in scenarios where it is necessary to apply business logic through stored procedures etc.

Good integration with MSSQL

Rating: 8 out of 10
Incentivized
June 21, 2018
Verified User
Analyst in Engineering
Information Services Company, 11-50 employees
Vetted Review
Verified User
SQL Server Integration Services
1 year of experience
Use Cases and Deployment Scope
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.
Pros
  • Visual programming makes configuration easy and accessible
  • The ability to code also allows users to implement complex logic for data manipulation and etc.
  • Easy integration with MSSQL Database instances.
Cons
  • Component properties are not very well defined, which makes the learning curve harder
  • As control flow and data flow often looking similar visually at first glace, it takes awhile to differentiate which one you are working on as users need to look at the tiny symbol and text on the tab to do so. A more straightforward color-coded or larger visual cue to differentiate between the two would make this easier.
Likelihood to Recommend
SSIS is suitable for MSSQL related projects/works due to how well it integrates and performs data manipulation. It is suitable for moderate data input ingestion rates but not suitable for projects where a high volume of data is required to be ingested and processed rapidly.

SSIS

Rating: 9 out of 10
Incentivized
August 10, 2017
Verified User
Consultant in Information Technology
Computer Software Company, 11-50 employees
Vetted Review
Verified User
SQL Server Integration Services
5 years of experience
Use Cases and Deployment Scope
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.
Pros
  • SSIS allows you to run many processes in parallel. Thus, you can run multiple data flows simultaneously to increase the throughput of the migration process.
  • SSIS provides many tools for transforming data during the migration process.
Cons
  • The one issue that I have with SSIS is that sometimes the business logic gets baked into the SSIS package. This can make it harder to debug. In some cases this makes sense if the source and destination is not a database. However, when using a database as a source I prefer to manipulate and transform the data via sql and then simply expose the dataset to SSIS after the data has been prepared. I find it easier to write and debug sql directly rather than working in SSIS. However, in cases when a database is not involved then putting the business logic in SSIS makes sense.
Likelihood to Recommend
SSIS is well suited for any processes that can be automated to move data from a source to a destination. However, I don't think SSIS can work directly with Rest API's during it's processing. If that is required than it would be necessary to build your own custom SSIS component to enable this functionality. Extending SSIS to permit this is possible.

If your back end RDBMS is SQL Server, SSIS gives you a bang for your buck.

Rating: 8 out of 10
Incentivized
April 27, 2018
Verified User
Consultant in Information Technology
Utilities Company, 1001-5000 employees
Vetted Review
Verified User
SQL Server Integration Services
6 years of experience
Use Cases and Deployment Scope
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.
Pros
  • Source systems connectivity (RDBMS, Flat Files etc)
  • Embedding SQL and other code in case of complex business logic and data transformations
  • Multitude of data transformation options
  • Ease of use, easy to learn
  • Skills availability in the market
Cons
  • version control/configuration management
  • Programmatic issues like NULL handling (it's RDBMS counterpart SQL Server database uses NULL differently)
  • The source connectivity options should be enhanced
Likelihood to Recommend
If the back end RDBMS is SQl Server and if you are migration from Oracle or DB2 to SQL Server, SSIS does the migration job very well. It's tightly integrated with SQL Server. However, issues like NULL handling etc persists. Also, if the integration platform has unsupported connectivity or drivers, then SSIS usage becomes challenging.

SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.

Rating: 10 out of 10
Incentivized
June 23, 2022
Verified User
Director in Sales
Management Consulting Company, 5001-10,000 employees
Vetted Review
Verified User
SQL Server Integration Services
3 years of experience
Use Cases and Deployment Scope
We used Integration Services to extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations. We also used the graphical Integration Services tools to create business solutions for the firm.
Pros
  • Create Packages in SQL Server Data Tools
  • Reuse Control Flow across Packages by Using Control Flow Package Parts
  • Build Integration Services User Interface
Cons
  • We can improve Integration Services error messages, including a list of most Integration Services errors and their description.
  • Improvement to create custom event handlers for these events to extend package functionality.
  • Better support for tools and wizards helping with Legacy Package Deployment.
Likelihood to Recommend
Integration Services is very helpful to solve complex business problems by copying or downloading files, loading data warehouses, cleaning and mining data, and managing SQL Server objects and data. It provides Graphical tools for building packages. Also, it helps with the SSIS Catalog database to store, run, and manage packages for business solutions.
Return to navigation