SSIS

SSIS

Customer Verified
Score 8.1 out of 10
SQL Server Integration Services

Overview

What is SSIS?

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

Recent Reviews

Worth of money

10 out of 10
June 23, 2022
As a BI / Data Analyst, I have to deal with multiple data source integrations independent of to live environment. So, I have to combine …
Continue reading
Read all reviews

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

Popular Features

View all 12 features
  • Connect to traditional data sources (55)
    8.8
    88%
  • Simple transformations (55)
    8.7
    87%
  • Complex transformations (54)
    7.7
    77%
  • Testing and debugging (50)
    6.6
    66%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SSIS, and make your voice heard!

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?

11 people want pricing too

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

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

Features

Data Source Connection

Ability to connect to multiple data sources

7.5Avg 8.3

Data Transformations

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

8.2Avg 8.4

Data Modeling

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

7.5Avg 8.1

Data Governance

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

7.2Avg 8.2
Return to navigation

Product Details

What is SSIS?

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

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

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Chris Morgan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Our laboratory uses SSIS to transfer data between servers and databases, to data warehouses, reporting services and to and from file sources in a complex SQL Server environment that includes Merge Replication and SQL Server Reporting Services. Besides internal transfer, transformation, and manipulation of data, including archiving of data, we use SSIS to export laboratory results to external systems and import scheduling and sampling information from external systems.
  • SSIS can query, filter, and transfer data between databases on different servers without establishing explicit trust relationships between those servers.
  • SSIS can be used to refresh a reporting database from a transactional source database, transforming or flattening the data and tables as necessary to facilitate reporting. This can be done incrementally, or by emptying and refilling the reporting database from scratch.
  • SSIS is configured through graphical interfaces that make it relatively easy to see the flow of data including where problems occur.
  • SSIS has a number of tools that allow you to debug SSIS packages and track down problematic data or configurations.
  • SSIS allows you to program Script Tasks in C# and VB allowing extremely powerful functionality including looping and sending consolidated alerts.
  • SSIS allows you to control virtually every part of the SSIS package (connections, variables, etc.) using configuration files so you can have one package that can be used in several different places (such as dev, test, and production environments) only by editing the configuration file that the package uses when the job is scheduled.
  • One of the most frustrating things about SSIS, at least in its 2008R2 incarnation, is that of the annotations. Formatting annotations, getting them to wrap in the box, etc., is either extremely difficult or impossible without editing the XML of the SSIS package. You also CANNOT copy and paste annotations, so if you have several similar ones, you have to type every one of them from scratch. It makes you want to scream.
  • In the 2008R2 incarnation, setting up tasks to pivot data is very tedious and non-intuitive. I have heard that this improved in SSIS 2012, along with performance. We are trying to upgrade our SSIS and SQL server environment to 2012 or 2014 as soon as possible.
  • Sometimes datatype conversion doesn't work implicitly when it should and you have to do it either explicitly with a query or with a datatype conversion task.
Whenever you are moving data from one database to another, either on the same server or a different one, SSIS is a great tool. This is true for one-time transfers because it is so easy to set up and configure what you want to happen, and it is true for automated transfers that occur every day or every hour. If complex transformations of the data are necessary, including filtering, generation of new columns, merging datasets, whatever, SSIS is the best tool out there for ETL. If the task takes place within a database or between databases on the same server, and the task can be accomplished with a simple SQL script, it will often perform much faster than an SSIS package and require fewer server resources.
Data Source Connection (2)
90%
9.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
84%
8.4
Data model creation
80%
8.0
Metadata management
90%
9.0
Business rules and workflow
70%
7.0
Collaboration
80%
8.0
Testing and debugging
100%
10.0
Data Governance (2)
95%
9.5
Integration with data quality tools
100%
10.0
Integration with MDM tools
90%
9.0
  • SSIS has allowed us to meet a complex variety of ETL needs without having to acquire a profound knowledge of application programming and the learning curve is really not bad considering the power available. We heavily depend on SSIS every day.
  • SSIS or SQL Server doesn't play nice with Sybase databases, and it takes some work to make ETL go smoothly between Sybase and SQL server databases, particularly since SQL Server Management Studio can't query certain Sybase formats.
  • It is included with SQL Server, so it is a very powerful tool included at no additional cost. It has saved us a lot of money over possible alternatives.
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, versatile and easy to use.
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
No
Luca Campanelli | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
In our department we use SQL Server Integration Services daily. The main use is to do data processing for several ETL processes. Thanks to the use of SQL Server Integration Services we can upload data to the data warehouse in different ways such as a bulk load or with incremental loads thanks to the use of SCD task data.
  • High data load speeds
  • Many data processing modes
  • Many data sources and destinations data possible
  • For some tools you need to integrate third-party packages
  • Depending on the version you must have the right visual studio version to develop and deploy
  • Not really intuitive
SQL Server Integration Services is optimal for any process of data extraction, data transformation and data loading, and can be used quickly for massive loads. It can be used for scheduled and incremental processes. It is not optimal for data structures that continuously change their structure because in this case it requires continuous changes and deploys.
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
60%
6.0
Data Transformations (2)
90%
9.0
Simple transformations
100%
10.0
Complex transformations
80%
8.0
Data Modeling (5)
62%
6.2
Data model creation
60%
6.0
Metadata management
80%
8.0
Business rules and workflow
50%
5.0
Collaboration
70%
7.0
Testing and debugging
50%
5.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
  • SSIS is integrated into SQL Server licenses
  • Once developed your packages are very stable and it requires relatively little maintenance
  • If used wisely, it saves a lot of working time
  • DataStage
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 training and good experience to create very high-performance tools.
4
In our department of DBAs we use sql server integration services daily. Through the use of Visual Studio and different versioning solutions, we can manage and follow the different ETL tools that we create for various needs in terms of development both in terms of maintenance (in different environments like Online, DWH etc.).
For what our infrastructure is, it does not require external support resources. We can independently manage the product and develop and perform maintenance directly amongst us by sharing our experience and through continuous updates on the latest functionality. On the support application side in case it should be necessary, it is possible to use them directly from MSDN usually provided by Microsoft.
  • Import data from external sources
  • Integration of heterogeneous data
  • Loading the data warehouse
  • Creation of real-time online solutions
  • Packages automation
  • Communications
  • ETL
  • Other data import
  • OLAP & Big Data integrations
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure.
No
  • Product Features
  • Product Usability
Working mainly in a Microsoft environment and working for most of the structures on SQL Server environments is definitely recommended. The optimal integration into the existing structure SQL Server Integration Services is included in the Microsoft SQL Server licenses and obviously being fully integrated. Also it is a very professional tool with high performance.
Should I decide personally whether to choose SQL Server integrationServices, I would first estimate any type of data structure and the technologies currently used in the company. I would estimate the different types of skills in the company. Based on my experience I am sure that I would definitely repeat the choice to use SSIS as tool of extraction transformation and loading of data.
  • Implemented in-house
No
Change management was a minor issue with the implementation
Start using SQL Server Integration Services does not require a big change organizational management, the important thing is to have defined an initial work plan well structured and clear, especially if you want to start using SSIS as the ETL tool for the population of a DataWarehouse implementation of a new or an existing structure
  • compatibility issues with software versions in use
  • integration of third-party tools
  • verall understanding of the product
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools.
For what is my experience I have rarely needed the Microsoft support, however when it was necessary to have, i always found all the answers on the MSDN, where I have not found an answer I had to read up through forums and sites dedicated to advanced developments of integration services or similar.
No
I've never had need special support on this product if not at the beginning of my experience when I had to attend a training course on using Microsoft SQL Server integration services and sql server analisys services, of course it is advisable to follow the study using the official books .
  • Bulk load
  • IMport data
  • Data trasformation
  • Manage data sources structurally dynamic
  • integrate complex scripts or .dll
  • control the updating of records without the use of SCD
No
in terms of usability, sql server integration services is very schematic and very little dynamic, but for the type of software this schematic is physiological.
When you gain the right technical expertise and once you really know the product usability becomes increasingly fast and simple, the important thing is not to be scared on the first approach.
Return to navigation