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?
27 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-25 of 53)- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 10%1.0
- Simple transformations
- 50%5.0
- Complex transformations
- 50%5.0
- Data model creation
- N/AN/A
- Metadata management
- 10%1.0
- Business rules and workflow
- N/AN/A
- Collaboration
- 10%1.0
- Testing and debugging
- 30%3.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- 20%2.0
SSIS, the must have extension for SSMS
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 50%5.0
- Simple transformations
- 90%9.0
- Complex transformations
- 70%7.0
- Data model creation
- 90%9.0
- Metadata management
- 80%8.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 50%5.0
- Testing and debugging
- N/AN/A
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- 30%3.0
- Connect to traditional data sources
- 80%8.0
- Connecto to Big Data and NoSQL
- 10%1.0
- Simple transformations
- 80%8.0
- Complex transformations
- 60%6.0
- Testing and debugging
- 40%4.0
One of the best on-premise ETL tools
- Connect to traditional data sources
- 70%7.0
- Connecto to Big Data and NoSQL
- 20%2.0
- Simple transformations
- 80%8.0
- Complex transformations
- 70%7.0
- Data model creation
- 70%7.0
- Metadata management
- 70%7.0
- Business rules and workflow
- 70%7.0
- Collaboration
- N/AN/A
- Testing and debugging
- 60%6.0
- Integration with data quality tools
- 50%5.0
- Integration with MDM tools
- 50%5.0
Amazing data warehousing tool
- Connect to traditional data sources
- 70%7.0
- Connecto to Big Data and NoSQL
- 90%9.0
- Simple transformations
- 100%10.0
- Complex transformations
- 90%9.0
- Data model creation
- 80%8.0
- Metadata management
- 70%7.0
- Business rules and workflow
- 90%9.0
- Collaboration
- 70%7.0
- Testing and debugging
- 50%5.0
- Integration with data quality tools
- 70%7.0
- Integration with MDM tools
- 80%8.0
Good for startups or companies with limited data variability, Big data companies will need better tools
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 80%8.0
- Simple transformations
- 100%10.0
- Complex transformations
- 90%9.0
- Data model creation
- 70%7.0
- Metadata management
- 60%6.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 90%9.0
- Testing and debugging
- 60%6.0
- Integration with data quality tools
- 50%5.0
- Integration with MDM tools
- 50%5.0
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 100%10.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 100%10.0
- Metadata management
- 90%9.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 100%10.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 80%8.0
- Integration with MDM tools
- 90%9.0
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 80%8.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 100%10.0
- Metadata management
- 70%7.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 90%9.0
- Testing and debugging
- 60%6.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- 80%8.0
Tool for data integration and migration
- Connect to traditional data sources
- 70%7.0
- Connecto to Big Data and NoSQL
- 90%9.0
- Simple transformations
- 70%7.0
- Complex transformations
- 80%8.0
- Data model creation
- 70%7.0
- Metadata management
- 60%6.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 70%7.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 80%8.0
- Integration with MDM tools
- 80%8.0
SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 100%10.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 90%9.0
- Metadata management
- 90%9.0
- Business rules and workflow
- 90%9.0
- Collaboration
- 70%7.0
- Testing and debugging
- 70%7.0
- Integration with data quality tools
- 80%8.0
- Integration with MDM tools
- 80%8.0
Worth of money
- Connect to traditional data sources
- 90%9.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 100%10.0
- Metadata management
- 90%9.0
- Collaboration
- 90%9.0
Data processing with SSIS
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 100%10.0
- Complex transformations
- 90%9.0
- Data model creation
- 90%9.0
- Metadata management
- 90%9.0
- Business rules and workflow
- 90%9.0
- Collaboration
- 100%10.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- 90%9.0
SSIS, free but not intuitive
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 80%8.0
- Complex transformations
- 80%8.0
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- N/AN/A
- Collaboration
- N/AN/A
- Testing and debugging
- N/AN/A
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
Provides value to cost and excellent with MSBI Stack, But needs more features/updates
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 10%1.0
- Simple transformations
- 90%9.0
- Complex transformations
- 60%6.0
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- 30%3.0
- Collaboration
- 40%4.0
- Testing and debugging
- 50%5.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
- Connect to traditional data sources
- 70%7.0
- Connecto to Big Data and NoSQL
- 50%5.0
- Simple transformations
- 80%8.0
- Complex transformations
- 70%7.0
- Business rules and workflow
- 70%7.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 80%8.0
SQL Server Express + SSIS basics
- 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
- Metadata management
- 80%8.0
- Business rules and workflow
- 70%7.0
- Collaboration
- 50%5.0
- Testing and debugging
- 70%7.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- 40%4.0
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 90%9.0
- Complex transformations
- 70%7.0
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- 80%8.0
- Collaboration
- 80%8.0
- Testing and debugging
- 90%9.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
- Connect to traditional data sources
- 80%8.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 100%10.0
- Complex transformations
- 100%10.0
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- 80%8.0
- Collaboration
- N/AN/A
- Testing and debugging
- 90%9.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- N/AN/A
SSIS Just Works
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 70%7.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Business rules and workflow
- 70%7.0
- Testing and debugging
- 60%6.0
- Integration with data quality tools
- 80%8.0
- Integration with MDM tools
- 80%8.0
Great Tool For ETL Design
- Connect to traditional data sources
- 80%8.0
- Connecto to Big Data and NoSQL
- 80%8.0
- Simple transformations
- 100%10.0
- Complex transformations
- 90%9.0
- Data model creation
- 90%9.0
- Metadata management
- 100%10.0
- Business rules and workflow
- 80%8.0
- Collaboration
- 80%8.0
- Testing and debugging
- 70%7.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- 80%8.0
Our use of SSIS
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 100%10.0
- Complex transformations
- N/AN/A
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- 100%10.0
- Collaboration
- N/AN/A
- Testing and debugging
- 100%10.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
SSIS enables you to build the data lake of your dreams!
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 100%10.0
- Complex transformations
- 100%10.0
- Data model creation
- N/AN/A
- Metadata management
- N/AN/A
- Business rules and workflow
- 90%9.0
- Collaboration
- 70%7.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
SQL Server Integration Services, worth a look
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 70%7.0
- Simple transformations
- 100%10.0
- Complex transformations
- 60%6.0
- Data model creation
- 50%5.0
- Metadata management
- 50%5.0
- Business rules and workflow
- 70%7.0
- Collaboration
- 80%8.0
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 90%9.0
- Integration with MDM tools
- 70%7.0
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 100%10.0
- Simple transformations
- 100%10.0
- Complex transformations
- 100%10.0
- Data model creation
- 40%4.0
- Metadata management
- 40%4.0
- Business rules and workflow
- 90%9.0
- Collaboration
- 70%7.0
- Testing and debugging
- 90%9.0
- Integration with data quality tools
- N/AN/A
- Integration with MDM tools
- N/AN/A
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- 100%10.0
- Simple transformations
- 100%10.0
- Complex transformations
- 80%8.0
- Data model creation
- 100%10.0
- Metadata management
- 70%7.0
- Business rules and workflow
- 90%9.0
- Collaboration
- 30%3.0
- Testing and debugging
- 70%7.0
- Integration with MDM tools
- 60%6.0