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.3

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.1

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

Reviews From Top Reviewers

View all reviews
(1-5 of 29)

SSIS- Mundane but Dependable

Rating: 7 out of 10
Incentivized
June 03, 2016
EL
Eugene LaRoche
.NET Team Lead
Mitsui Sumitomo Insurance Group (Insurance, 201-500 employees)
Vetted Review
Verified User
SQL Server Integration Services
7 years of experience
View profile
Use Cases and Deployment Scope
SSIS is utilized as a systems and data integration tool, and for performing a variety of ETL tasks. It is utilized by the IT department to support business applications, particularly where two or more systems require data exchange. It is a mature product (stable and reliable) and comes as part of standard SQL Server implementations so its fairly simple to utilize.
Pros
  • SSIS Integrates very well with other Microsoft products including Excel and Access. Other ETL tools may have a difficult time integrating with Access, so we have observed SSIS to be superior in this regard.
  • SSIS has the capacity to do a fast bulk load (BCP) with transformations, within the bulk load itself. This feature is not available when utilizing the BCP utility outside of SSIS or from other ETL tools. To be clear, the transformation is occurring within the BCP component itself. Other ETL tools will have to utilize a non-BCP load (slower) or do the ETL after the load. This is a great feature I have not seen replicated in other tools.
  • SSIS integrates seamlessly with SQL Server RDBMS, including SQL Jobs and Stored Procedures.
  • SSIS has nice support, tools, and wizards for fixed length file processing.
Cons
  • SSIS IDE (SQL BIDS) is lacking, particularly when compared to Visual Studio for .NET development. It was carried over (at least in look and feel) from the legacy DTS tool. It could use a complete redesign from scratch. Considering how superior the VS .NET IDE is, the inferior SSIS BIDS IDE is unacceptable.
  • SSIS is very Microsoft centric. This is a strength when dealing with pure MS technologies, but becomes a weakness when dealing with disparate, distributed systems, including cloud computing. Other ETL tools for example easily integrate with everything from AWS to Google Drive to Sales Force.
  • SSIS deployment model is clunky and non-intuitive.
Likelihood to Recommend
SSIS is best suited for use in a pure Microsoft environment, or where interfaces to external systems are file based. It is not ideal for integration into disparate systems that are not interfaced via flat file. SSIS is also ideal when utilizing the job scheduler built into SQL Server, as it is seamlessly integrated with SSIS. In other words, it's very easy to schedule an SSIS package to run automated using the SQL job scheduler. Running SSIS packages from other job schedulers is more problematic, unless that tool has built in SSIS support.

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.

SSIS Addict

Rating: 8 out of 10
Incentivized
March 29, 2017
DM
David Milillo
Director Of Development
i.Predictus (Marketing and Advertising, 51-200 employees)
Vetted Review
Verified User
SQL Server Integration Services
8 years of experience
View profile
Use Cases and Deployment Scope
Integration Services is the primary extraction, transformation, and loading tool we use to populate our SQL Server and Azure SQL DB and DW for our data and our clients' data. We do a majority of our logic for preparing both reporting and application data within SSIS components, scripts, or within T-SQL Stored Procedures executed within SSIS Control flows. It is only used within my group but my group is the only group directly populating our reporting databases.
Pros
  • Native data connections to SQL Server and Azure SQL DB and DW
  • Flat file processing
  • .NET C#/VB scripting
  • Ease of use in designing and implementing control flows within conditional processing and looping
Cons
  • Integration with Access/Excel should be more seamless and less problematic
  • CASS certified address standardization
  • Higher performing Slowly Changing Dimension functionality
  • SFTP
  • Incremental loading (deletion, upsert, etc.)
  • PowerBI integration. I really really really want to be able to refresh reports via IS packages
  • More Azure administration tasks
  • Office365 and Sharepoint integration
Likelihood to Recommend
Well suited:
  1. Full refresh loading files (Excel and Flat File) into SQL Server.
  2. Integrating .Net (VB/C#) scripting
Less suited:
  1. Incremental loading
  2. OLAP database loading
Not suited:
  1. Streaming, real-time/near real-time loading
  2. Big data loading

SQL Server Integration Services: A Great "Free" ETL Tool for Most Use Cases

Rating: 8 out of 10
Incentivized
June 27, 2019
Verified User
Team Lead in Information Technology
Information Technology and Services Company, 10,001+ employees
Vetted Review
Verified User
SQL Server Integration Services
10 years of experience
Use Cases and Deployment Scope
In my work in the health care field, we use SQL Server Integration Services as our default ETL tool of choice for pulling data into SQL Server from Teradata, Oracle, flat file and other SQL Server databases, and for creating data extracts to send to our clients, typically in the form of flat files.
Pros
  • SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
  • It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
  • When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.
Cons
  • SSIS has been a bit neglected by Microsoft and new features are slow in coming.
  • When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
  • While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.
Likelihood to Recommend
SQL Server Integration Services is extremely well built for creating packages to run ETL operations in environments where the structure of the source and/or destination data never or rarely changes, however, it tends to be difficult to maintain packages in production environments where the structure of the data changes frequently.

SSIS Cheap and easy to use

Rating: 7 out of 10
Incentivized
October 29, 2015
PM
Pancratius Mukeh
BI Consultant
Saxony Partners (Information Technology and Services, 11-50 employees)
Vetted Review
Verified User
SQL Server Integration Services
6 years of experience
Use Cases and Deployment Scope
We use SQL Server Integration Services to pull data from FTP sites.
Pros
  • Our clients have branches and each branch generates a flat file and loads to a remote site from which we pull and consolidate the data and report from the consolidated data.
  • SSIS would allow [us] to execute a batch file which will pull the files and decrypt.
  • SSIS transformations are easy to use when [they] loop around the files in the same folder.
Cons
  • SSIS expressions are difficult to read and comprehend.
  • SSIS fuzzy loop up transformation performance needs to be optimized.
  • SSIS packages code should be easy to copy and modify so that it can easily be replicated just like BIML.
Likelihood to Recommend
Can SQL Server Integration Services (SSIS) perform multiple unrelated tasks within a package?
Return to navigation