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?
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.
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)- SSIS provided good value when there were few competitors, for somebody already using SQL Server Enterprise Edition.
SSIS, the must have extension for SSMS
- Reduce data migration task to half of time.
- Additional investment to integrate with other company tools.
- Rapid integration with source systems has provided a high ROI however this is based on using BIML in conjunction with SSIS.
- Combination of workflow, data manipulation and scripting make it a very capable data integration tool.
One of the best on-premise ETL tools
- Negative impact - We still need plugins like CozyRoc for basic things like connecting to SFTP. This slows development
- Positive impact - We don't need to pay extra for this. It comes with SQL Server license.
Amazing data warehousing tool
- We can easily merge data on a variety of databases.
- Loading and migrating data is fast.
- It offers a simple system for analyzing raw data.
Good for startups or companies with limited data variability, Big data companies will need better tools
- Good ROI for companies using the MS suite of tools (SQL Server / SSDT) without having to purchase additional tools.
- SQL Server is expensive, so running very complex processes using SSIS will become quickly very expensive.
- Able to managed very dense healthcare data in this software.
- Creation of data models and automated scripts.
- SQL Server Integration has helped in data management by cutting down on collaboration times.
- SQL Server Integration has helped in data query & complex data modeling very effectively.
- SQL Server Integration has helped in designing better workflows.
Tool for data integration and migration
- More cost-efficient than other ETL tools of the same stature
- No extra requirement of learning anything other than SQL itself
- Helps in analysing customers' data by collecting them at a single place
SQL Server Integration Services (SSIS) is a winner and helps solve many business problems effectively.
- Faster loading of new data (imports).
- Very effective data cleansing or transformation of dirty data.
- Managing critical DBA tasks like purging old files or indexing a database.
Worth of money
- Clear sense of data
- Data modeling
- Multiple Data resource handling
Data processing with SSIS
- Helped to increase revenue for the clients
- Saved big time and work
- Increased productivity
SSIS, free but not intuitive
- Without this, we would have to manually update a spreadsheet of our SQL Server inventory
- We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
- We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
Provides value to cost and excellent with MSBI Stack, But needs more features/updates
- Faster loads.
- Cheaper alternative but more development & compromise on performance.
- Support with cloud tech other than Microsoft.
- Saved our IT organization time by making reports of their their systems compliance.
SQL Server Express + SSIS basics
- Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
- Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
- The employee number, responsible for data management was reduced from 4 to 1 person
- Being able to automate data integration across systems has always been a great source of savings, so the ROI is there.
- The nice thing about SSIS is that it can continue to grow, so a project this year provides and ROI for every year going forward, and frees up time to implement additional integration opportunities further increasing ROI.
- It allows for easier automation
SSIS Just Works
- Consolidation into a standard tool for data movement makes maintenance and administration easier.
- The extensibility of the tool has allowed us to fill the gaps with 3rd party add-ons.
Great Tool For ETL Design
- Paying a license fee to the SSIS ETL vehicle for our enterprise projects increases our costs.
- Because it is a powerful and performance ETL tool, data increases our business productivity.
Our use of SSIS
- Positive - easier to manage and maintain data imports and maintain consistency over time.
- Positive - reusable projects reduces time for repetitive tasks.
- Negative - learning curve. Variety and flexibility of possible solutions can be overwhelming.
SSIS enables you to build the data lake of your dreams!
- By using SSIS, we have been able to eliminate simple, redundant data move operations that were conducted manually.
- We have been able to build a stable data repository that combines data from different sources and provides a more holistic view of the business's data.
- SSIS provided a flexible framework that we were able to use to connect to a variety of data sources--Oracle, SQL Server, Teradata, CSV, and web--which enabled us to build a system for business-critical reporting.
SQL Server Integration Services, worth a look
- We partner with other companies to help provide value to their customers. We had a number of them that requested reporting sent to their customers monthly. Our traditional Devs spec'd they would need up to a week toget that coded, tested and released. With SQL Server Integration Services and SQL Server Reporting Services we had the first iteration out in a day. This sends out over 3,000 reports, using our Partners Branding we get these out in less than 1 hour saving development resources.
- In a growing company from Startup to Enterprise, integrating our home grown order entry into our ERP system was proving difficult by hand. Once I implemented SQL Server Integration Services we had it done in less than a month. This reduced our project implementation time by over 1 month which saved consulting time and expenses.
- We use SQL Server Integration Services to backup our production boxes, cleanse and change the data to comply with different countries regulatory requirements, and restore that data to our Development and Test environments allowing our developers to have the most recent data set possible.
- Enabled migration of complex business/customer data with one person resource.
- Launched automated ETL package within weeks with less than 2 person resource.
- No production failures/downtime since launch.
- Like any IT department, we almost always have an MS SQL license and therefore also access to this tool, though the free version also works just fine with a little less functionality.
- Makes things like data cleaning or integration easy.
- Scheduling and running SISS jobs can be done in many ways, very flexible.
- Negative. I would say source control is difficult, there’s no elegant solution.