SSIS

SSIS

Customer Verified
About TrustRadius Scoring
Score 8.2 out of 100
SQL Server Integration Services

Overview

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
  • Simple transformations (57)
    8.8
    88%
  • Connect to traditional data sources (57)
    8.7
    87%
  • Complex transformations (56)
    7.8
    78%
  • Testing and debugging (52)
    6.9
    69%

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!

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?

8 people want pricing too

Alternatives Pricing

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

Features Scorecard

Data Source Connection

7.6
76%

Data Transformations

8.3
83%

Data Modeling

7.8
78%

Data Governance

7.4
74%

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 Simple transformations highest, with a score of 8.8.

The most common users of SSIS are from Enterprises (1,001+ employees) and the Information Technology & Services industry.

Comparisons

View all alternatives

Reviews and Ratings

 (257)

Ratings

Reviews

(1-25 of 57)
Companies can't remove reviews or game the system. Here's why
Jonathan Leong | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
The management and transformation of data in the entire organization have been a great challenge. Since we have discovered SQL Server Integration Services, there has been great improvement in all data control capacities. It has the capability of collecting data from various sources and transforming it into a useful business asset. It fully controls all SQL servers that we have deployed in both cloud servers and on-premise.
Score 8 out of 10
Vetted Review
Verified User
Review Source
SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that we use to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading, and transformation like cleaning, aggregating, merging data, etc. It makes it easy to move data from one database to another database. SSIS can extract data from a wide variety of sources like SQL Server databases, Excel files, Oracle and DB2 databases, etc.
Abhinav Choudhary | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
So we are a data company where in almost a terabyte of data is generated everyday. The data that is procured is shared with the customers in varied forms such as text file, csv etc. SQL Server Integration Services gives us the ease and flexibility to export the data and choose our respective format within some clicks.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SQL Server Integration Services (SSIS) as part of our on-premise Data Warehouse architecture. We have an ELT pattern and SSIS is used almost exclusively for the Extract and Load steps. Almost all packages are generated using BIML (Business Intelligence Markup Language) as a means of templating and then scripting them.
Score 6 out of 10
Vetted Review
Verified User
Review Source
SSIS is an on-premise data transformation tool and the first major ETL tool we have used. We use it to ETL data from Workday, and other internal applications/databases to our internal databases. The product addresses the issue of getting data from CSV files from our SFTP and performing update/insert/delete operations on the data in our internal databases.
Robbie Scott | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
When working with data from several vendors, we often utilize SQL Server Integration Services to bring everything together. For reporting purposes, SQL Server Integration Services is the data-gathering engine. The information is then stored in our primary SQL database. Every department in our company uses it. Using SQL Reporting Services, it centralized data on which systems are included in which vendor products (and whether or not agents have been deployed, for example). It's been a while since the last time anything was checked.
Vishal Shah | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Shubham Rawat | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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 tools is awesome as it is easy to integrate Microsoft SQL servers with different BI tools like google data studio and PowerBI.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft's SQL Server Integration helps in keeping a track of our data dump in a suitable & orderly manner. The service not only helps in making sure the data is readily available but it also helps in bifurcating the data according to our needs & requirements. The data is quickly available when needed & helps in our workings on a daily basis.
Rao Tahir | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
In our organization, we have two Microsoft windows servers. We integrate their data sync via SQL Server Integration Services. It's easy for us to migrate our data from one server to another server. The debugging capabilities are great, particularly during data flow execution. We can look into the data and see what's going on in the pipeline.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
June 23, 2022

Worth of money

Score 10 out of 10
Vetted Review
Verified User
Review Source
As a BI / Data Analyst, I have to deal with multiple data source integrations independent of to live environment. So, I have to combine data query many query tables. I need to maintain the schemas of databases with multiple data sources.
Chris Guru | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are in the middle of data Migration projects from Legacy to Cloud (Azure). The SQL Server Integration Services provides the solution that we need specifically for this project objective where we can handle source and landed data as when needed. It's a competent product from Microsoft that supports and integrates well with other Microsoft tools to meet our project objectives, and goals.
John Ramírez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 6 out of 10
Vetted Review
Verified User
Review Source
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 exactly intuitive in my opinion. I had not used this before my current job, and it was already setup when I joined. I've had to edit some of those jobs a handful of times and I just have not yet been able to make it 'click' in how it works. I seem to think oppositely of how this was designed (potentially just the jobs I've had to interact with), but almost everything is counter-intuitive.
Score 7 out of 10
Vetted Review
Verified User
Review Source
SQL Server Integration Services has been useful in implementing Extract, Load, and transform logic from various sources and destinations. we also use it to download data files from SFTP, FTP locations. We use it to refresh extract in tableau and run other 3rd party services via executing process tasks. It has been useful to address many other such challenges.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SQL Server Integration Services to consolidate data from multiple vendor products. SSIS is the engine that gathers that data and stores it on our main SQL database instance for reporting purposes. It is being used by the enterprise in our organization. It created one pain of glass using SQL Reporting Services to show what systems are in what vendor products - such as agents installed yes/no? Last checking date/time, etc...
Vladimir Salnikov | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We are using the SSIS as a major data export/import & converter between different data sources, including relatively old legacy stuff out from 90th. The beauty of SSIS is really advanced capabilities of data converts and mix up the data from different sources with all respect to keys and data relations. We use this mostly as an addition to the SQL Server Express edition (as a part of the import/export wizard) but on the sandbox I doing the tests of SQL Server 2016 Standard edition to mix up several RDBMS for data extraction into one data warehouse.
Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Server Integration Services is used by our department to support the entire organization. Several developers design our packages and as well our DBA team who develops, reviews, and implements these in production.
SSIS is a critical component in making data available across disparate systems from custom databases to local vendor and online applications.
February 17, 2020

SSIS Just Works

Score 8 out of 10
Vetted Review
Verified User
Review Source
SSIS is being used for data interchange. This includes using it for traditional ETL to a corporate data warehouse, as well as for the production or intake of flat files for interchange with external sources. Sources include traditional RDBMS, web services based cloud sources, and flat files. We are beginning the process of extending SSIS to the cloud in conjunction with Azure Data Factory.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
In my department, we design and manage ETL processes. We use SQL Server Integration Services (SSIS) to design a data warehouse. To create a data warehouse, we can make the stage layer and DWH layers with the SSIS ETL tool. We create data marts using aggregate functions in the SSIS ETL tool. In addition, we use the SSIS ETL tool to move data between databases.
November 24, 2019

Our use of SSIS

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use SQL Server Integration Services to import data into and out of our main SQL server databases. This data comes from a variety of external sources and sometimes there is data format mismatch between source and destination. With an SSIS package, we can retain the mapping and data formats integrity from the source to the destination without having to go through the process every time.