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

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

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.

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

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

(1-5 of 52)

SQL BI Stack review

Rating: 7 out of 10
October 27, 2015
NF
Vetted Review
Verified User
SQL Server Integration Services
8 years of experience
Used across the organization to move data, develop data marts and build front end reports
  • There is flexibility to Transform various data. There are also templates that help to guide you in using best practices such as building TYPE 2 loading of Data Warehouse tables
  • There are many transformation features that allow for sorting, lookups, using a variety of data sources and targets. It is a full featured product.
  • There are a lot of properties that allows you to customize data flows to suit your needs.
Cons
  • Having to sort prior to merging is a pain.
  • Working on very large data sets approaching 1 billion records require a lot of pre-planning. Teradata handle large data sets better
  • Error messaging is sometimes not explicit enough. "Something went wrong" is one of my "favorites" that I have seen
Well suited for data sets that are not too large < 500,000,000. Not well suited for handling very large data sets.

Data processing with SSIS

Rating: 9 out of 10
June 23, 2022
JR
Vetted Review
Verified User
SQL Server Integration Services
2 years of experience
Being part of the Healthcare department, we need to automate the data transfer from and to the company and hospitals. SQL Server Integration Services, allowed us, to create a robust platform, to process millions of records from each hospital everyday, the whole year, just taking care of small incidents, such formats, not related to the SSIS, itself. So, we relied on this process for keeping the data and the collection, working efficiently and providing outstanding service.
  • Data transfer
  • Automation
  • Programability
  • Scheduling
Cons
  • Clarity on errors
  • Support
Automation for data transfer, where you don't need to be moving or copying any data manually.
Processing data, for ETL, so you can just get the files, using something like FTPs automation and the data will be processed, and then you can just work on your reports or do all the BI needed for the company

Amazing data warehousing tool

Rating: 8 out of 10
June 24, 2022
RS
Vetted Review
Verified User
SQL Server Integration Services
4 years of experience
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 Services to copy and download large files as well as to draw out and modify data from several sources of data like XML data files, DB2 databases, and relational data sources and then load the data into a single destination.
  • 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.
We have used SSIS to perform extensive data migration tasks from various sources like DB2 databases, SQL server databases... It works speedily making it easy for us to move data from one database to the other. It also has a GUI that helps us extract, transform, and clean data easily without writing code. It works well except for the error messages.

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

Rating: 8 out of 10
June 24, 2022
VS
Vetted Review
Verified User
SQL Server Integration Services
3 years of experience
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. It is an MS native and easy-to-use ETL tool that comes with the SQL Server Data Tools suite. I use the tool personally to deploy ETLs for business stakeholders as a request arises.
  • 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).
Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.

A Reliable Data Preparation Tool.

Rating: 8 out of 10
May 06, 2016
TJ
Vetted Review
Verified User
SQL Server Integration Services
12 years of experience
SSIS is used by the IT department for extracting, transforming, and loading data. The most common application for SSIS would be for cleansing and restructuring data while it is being loaded into a data warehouse.
  • Providing developers with a wide range of architectural options.
  • Providing the ability to connect to a wide array of data sources.
  • Proving many different deployment options.
Cons
  • While SSIS does provide a plethora of architectural options, all of these options can at times be overwhelming. Some competing products offer a more straight forward and streamlined approach.
  • SSIS does not currently provide any templates, although this is supposed to be addressed with the upcoming release of SQL Sever 2016
  • Connecting to Oracle databases is not easy, SSIS still requires the installation of other tools.
SSIS is a good fit when you have structured data. If you're looking to prepare unstructured data for doing text analytics, this is not the right tool.
Return to navigation