Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.A high-performance ETL productIn our department we use SQL Server Integration Services daily. The main use is to do data processing for several ETL processes. Thanks to the use of SQL Server Integration Services we can upload data to the data warehouse in different ways such as a bulk load or with incremental loads thanks to the use of SCD task data.,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,9,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,Visual Studio.NET, SQL Data Warehouse, Microsoft SQL Server,4,,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,8,No,Product Features Product Usability,Should I decide personally whether to choose SQL Server integrationServices, I would first estimate any type of data structure and the technologies currently used in the company. I would estimate the different types of skills in the company. Based on my experience I am sure that I would definitely repeat the choice to use SSIS as tool of extraction transformation and loading of data.,Implemented in-house,No,Change management was a minor issue with the implementation,compatibility issues with software versions in use integration of third-party tools verall understanding of the product,10,8,No,I've never had need special support on this product if not at the beginning of my experience when I had to attend a training course on using Microsoft sql server integration services and sql server analisys services, of course it is advisable to follow the study using the official books .,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,No,8
SQL Server Integration Services
187 Ratings
Score 8.1 out of 101
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>TRScore

SSIS Reviews

187 Ratings
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Do you work for this company?

Show Filters 
Hide Filters 
Showing 1 of 187 SSIS ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-1 of 1)

Companies can't remove reviews or game the system. Here's why.
Luca Campanelli profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source


The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools.
Read Luca Campanelli's full review

Feature Scorecard Summary

Connect to traditional data sources (31)
Connecto to Big Data and NoSQL (25)
Simple transformations (31)
Complex transformations (31)
Data model creation (16)
Metadata management (20)
Business rules and workflow (24)
Collaboration (23)
Testing and debugging (29)
Integration with data quality tools (23)
Integration with MDM tools (23)

About SSIS

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Categories:  Data Integration

SSIS Technical Details

Operating Systems: Unspecified
Mobile Application:No