Business Intelligence
Now Reading
Microsoft SQL Server Integration Services
2
Review

Microsoft SQL Server Integration Services

Overview
Synopsis

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions.

Category

ETL Software

PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.7
7.6
Features & Functionality
7.5
8.5
Advanced Features
7.6
6.8
Integration
7.7
8.5
Performance
7.5
7.7
Customer Support
7.6
7.2
Implementation
8.0
Renew & Recommend
8.0
Bottom Line

Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

7.6
Editor Rating
7.9
Aggregated User Rating
6 ratings
You have rated this

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Integration Services is used to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

The packages can work alone or in concert with other packages to address complex business needs. Integration Services can 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.

Integration Services includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

You may like to read: Top Extract, Transform, and Load, ETL Software, How to Select the Best ETL Software for Your Business and Top Guidelines for a Successful Business Intelligence Strategy

Filter reviews
User Ratings





User Company size



User role





User industry





2 Reviews
  • Corinna
    August 10, 2017 at 10:15 am

    A package holds a variety of elements that define a workflow.

    Company size

    Medium (50 to 1000)

    User Role

    Consultant

    User Industry

    Computer

    Rating
    Ease of use8.4

    Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

    Features & Functionality8

    Parameters allow you to assign values to properties within packages at the time of package execution.

    Advanced Features8.7

    Integration8

    Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources.

    Training 8

    Customer Support8

    Renew & Recommend8

    ADDITIONAL INFORMATION
    Use the graphical Integration Services tools to create solutions without writing a single line of code.

  • Jonathan
    January 3, 2018 at 10:16 am

    Extract, transform and consolidate data from multiple relational databases and sources.

    Company size

    Enterprise (>1001)

    User Role

    Executive

    User Industry

    Computer

    Rating
    Ease of use8

    Features & Functionality8.9

    Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

    Advanced Features8.4

    Integration8.9

    Training 8.9

    Customer Support8.9

    Implementation8

    ADDITIONAL INFORMATION
    Program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
100%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%