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

Worth of money

10 out of 10
June 23, 2022
Incentivized
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 11 features
  • Connect to traditional data sources (53)
    8.8
    88%
  • Simple transformations (53)
    8.5
    85%
  • Complex transformations (52)
    7.7
    77%
  • Testing and debugging (48)
    6.1
    61%
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?

24 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.2

Data Transformations

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

8.1
Avg 8.4

Data Modeling

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

7.4
Avg 8.2

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

(259)

Attribute Ratings

Reviews

(1-25 of 53)
Companies can't remove reviews or game the system. Here's why
Alex Bransky | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Incentivized
  • SSIS is good for small, simple data syncs.
  • SSIS is good for moving data quickly into SQL Server (good batch performance).
  • Very hard to diff for code review when changes are made.
  • Very buggy IDE (freezes in Visual Studio, doesn't always show what's in the underlying XML properly)
  • Lacking lots of features or more modern tools, like ability to monitor for changes to the source schema and apply them to the target.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Offers real-time, message-based capabilities
  • Tight integration with SQL Server and visual studio
  • Ease and speed of implementation
  • Standardized data integration
  • Sometimes create issues in non-windows environments.
  • SSIS lacks support for alternative data integration styles.
  • Problematic integration with other products.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Easily connect with a wide variety of sources.
  • Provide control and flow to job execution order.
  • Able to extend functionality through scripting tasks.
  • Not flexible when source/target tables and file formats change.
  • Inflexible with regards to varying data types when Excel spreadsheets are used as a source or columns are added (as per previous item).
  • Occasional issues around mixed development and production x86/x64 run times can be frustrating.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
  • Connect to various sources
  • Basic transformations are included
  • Connect to various destinations
  • We still need plugins to connect to SFTP and other sources. Many vendors in the market give this by default
  • It's an ETL tool and the ability to do ELT or ETLTL means spinning up more pipelines and packages
  • It still has compatibility issues in Visual Studio 2017
Robbie Scott | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • 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.
  • 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.
Vishal Shah | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • 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
  • 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).
Shubham Rawat | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Assists in connecting to several data sources and loading the resulting data.
  • Less expensive than other ETL tools of same stature.
  • Does away with the requirement for coding scripts.
  • There isn't a lot of room for building user-required automation.
  • Some activities need manual labour, such as exporting multiple tables in CSV format one at a time.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Data Mapping & Integration
  • Maintaining data sources as per needs
  • Keeping track of all activities pertaining to data sources
  • Speed at which data is retrieved from the data sources
  • Ease of connecting to various data sources
  • Integration with other cloud services
Rao Tahir | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Encrypt files with SSIS and send them to various network locations this way we solve complex business problems.
  • We can migrate DTS packages to SSIS while choosing to run DTS packages using DTS runtime or incorporate DTS packages into SSIS this way we migrate DTS packages to SQL Server Integration Services.
  • We can transform data to make sure it complies with the rules of the database they are migrating to other servers with Integrations Services.
  • User-required automation needs much more scope.
  • Exporting numerous tables in CSV format has to be done one by one by manual.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Create Packages in SQL Server Data Tools
  • Reuse Control Flow across Packages by Using Control Flow Package Parts
  • Build Integration Services User Interface
  • 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.
June 23, 2022

Worth of money

Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Integration with multiple data sources
  • Creating Schemas
  • Data modeling
  • Data cleaning
  • Ease of use for initial get into application
  • Application Loading
Score 6 out of 10
Vetted Review
Verified User
Incentivized
  • Runs flawlessly after setup properly
  • Powerful, as mentioned
  • Free
  • Confusing operation, even with its gui
  • Requires special install and setup
  • Requires the Visual studio integration services install (separate interface from SSMS)
  • Could be more easily integrated into SSMS, but may also be used for other products that I'm not aware of
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • If the job fails, we are alerted
  • It has a easy to use GUI to build projects
  • Does well with gathering data from different types of data sets
  • Converting flat files of data requires a data transformation that is tedious
Vladimir Salnikov | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Extraction and convert data from various sources
  • Pipelining in the data extraction process
  • Unions between different data sources akin one meta datasource
  • Some labels in Visual Studio snap-in for MS SQL Server are collapsed on non-English (German & Russian tested) locales.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • SQL Server Integration Services design of dataflows allow us collect and merge data from a large variety of sources.
  • The structure of packages in a solution allow us to separated distinct functions yet share a common collection of parameters to ensure consistency.
  • The availability of environments to provide differing parameters is also a powerful option to allow us to design reusable solutions.
  • The deployment process could use the improvement of deploying the Parameters into an environment of choice. Having to do this manually is time consuming and error prone.
  • Propagation of values from within a package to a parent package is lacking. This is helpful when using a parent package to execute and report on a collection of smaller related packages.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Data migration is pretty fast.
  • SQL Server is highly compatible with the database.
  • We receive errors in moving JSON data to the database. It does not work efficiently in JSON-related data.
  • ODBC connections give a connection error after a certain period of time.
November 24, 2019

Our use of SSIS

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Easy to manage projects and packages.
  • Ideal for repetitive tasks.
  • Can handle complex tasks consisting of multiple, diverse packages.
  • Include SSIS in the default installation of SQL.
  • The flexibility and different packages and options can make it confusing for first-time users.
  • Recommendations in the selections could make it easier to build a solution.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Handles multi-step, complex data moves.
  • Pulls from a variety of data sources.
  • Add-ons are readily available to extend their usefulness.
  • Integration with SQL Server and data tools.
  • The package publishing feature has gotten better over the years, but it could still be simplified.
  • Incorporating features from add-ons into the standard application would be helpful (mostly in relation to data sources).
  • Easier configurations for multiple publishing targets (dev/test/prod) with associated data connections.
Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • It sits inside of Visual Studio and SSMS so you have a consistent look and feel across toolsets
  • Extensions. We use Pragmatic work transforms that seamlessly fit into SSIS to make certain tasks easier
  • Performance. SSIS is not the fastest tool out there but it is more than enough for our needs and since it is bundled with SQL Server you get great value.
  • Funny thing, working with Excel requires hacks and work arounds. Really wish Microsoft would fix this.
  • More transformations to reduce the need of 3rd party tools. Tasks like SFTP would be nice.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Ease of use - can be used with no prior experience in a relatively short amount of time.
  • Flexibility - provides multiple means of accomplishing tasks to be able to support virtually any scenario.
  • Performance - performs well with default configurations but allows the user to choose a multitude of options that can enhance performance.
  • Resilient - supports the configuration of error handling to prevent and identify breakages.
  • Complete suite of configurable tools.
  • Connection managers for online data sources can be tricky to configure.
  • Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
  • Mapping destination using OLE DB command is difficult as destination columns are unnamed.
  • Excel or flat file connections are limited by version and type.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Almost no programming is needed, like drawing simple flow diagrams.
  • If you want to be more advanced you can add some VB or C# programming if needed.
  • Microsoft tool using all the great connectors, using any data source
  • Easy to add a third part like Cozyroc
  • File handling
  • Integration with office tools could always be improved, MS, as usual, provides these 80% solutions to make room for third vendors.
  • Error message or event handling, better messages and link to processes.
Return to navigation