Overview
What is SSIS?
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
SSIS, the must have extension for SSMS
Rapid and low cost integration with various sources for a DW
One of the best on-premise ETL tools
Amazing data warehousing tool
Good for startups or companies with limited data variability, Big data companies will need better tools
Data integration and migration are made easier with this tool.
Trust Microsoft to vanish your data integration troubles
Tool for data integration and migration
SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
Worth of money
Data processing with SSIS
SSIS, free but not intuitive
Provides value to cost and excellent with MSBI Stack, But needs more features/updates
Great product to consolidate data for SQL Reporting purposes
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
- Connect to traditional data sources (53)8.888%
- Simple transformations (53)8.585%
- Complex transformations (52)7.777%
- Testing and debugging (48)6.161%
Pricing
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?
26 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.
Product Demos
Demonstration of Multicast transformation in SQL Server Integration Services (SSIS)
SSIS Tutorial Part 78- What is Multicast Transformation in SSIS (Quick Demo)
SSIS Tutorial Part 119-Execute SQL Task (Full Result Set) Demo in SSIS Package
SSIS Tutorial Part 72- What is Conditional Split Transformation in SSIS (Quick Demo)
SSIS Tutorial Part 02- How to Load Tab Delimited File To SQL Server Table in SSIS Package
Features
Data Source Connection
Ability to connect to multiple data sources
- 8.8Connect to traditional data sources(53) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
- 6.2Connecto to Big Data and NoSQL(40) Ratings
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 8.5Simple transformations(53) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 7.7Complex transformations(52) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Modeling
A data model is a diagram or flowchart that illustrates the relationships between data
- 8.6Data model creation(27) Ratings
Ability to create and maintain data models using a graphical tool to define relationships between data
- 7.1Metadata management(33) Ratings
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
- 8.1Business rules and workflow(42) Ratings
Ability to define and manage business rules and workflows
- 7.3Collaboration(38) Ratings
Collaboration is enabled by a shared repository of project information and metadata
- 6.1Testing and debugging(48) Ratings
Tool to debug and tune for optimal performance
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 7.4Integration with data quality tools(36) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 6.5Integration with MDM tools(36) Ratings
Integration with master data management tools to ensure data consistency across the organization
Product Details
- About
- Tech Details
- FAQs
What is SSIS?
SSIS Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(259)Attribute Ratings
Reviews
(1-2 of 2)SSIS is terrific for all your ETL needs.
- 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.
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 80%8.0
- Simple transformations
- 100%10.0
- Complex transformations
- 100%10.0
- 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
- 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.
A high-performance ETL product
- 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
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 60%6.0
- Simple transformations
- 100%10.0
- Complex transformations
- 80%8.0
- 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
- 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
- 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
- Product Features
- Product Usability
- Implemented in-house
- compatibility issues with software versions in use
- integration of third-party tools
- verall understanding of the product
- 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