Good integration with MSSQL
June 21, 2018
Good integration with MSSQL
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
It is mainly used by technical analysts with the purpose of delivering data integration and reporting projects to customers. It addresses the need for complex multi-source data ingestion, data manipulation, and integration to a MSSQL database.
- Visual programming makes configuration easy and accessible
- The ability to code also allows users to implement complex logic for data manipulation and etc.
- Easy integration with MSSQL Database instances.
- Component properties are not very well defined, which makes the learning curve harder
- As control flow and data flow often looking similar visually at first glace, it takes awhile to differentiate which one you are working on as users need to look at the tiny symbol and text on the tab to do so. A more straightforward color-coded or larger visual cue to differentiate between the two would make this easier.
- As it is part of the SQL related products, customers are more receptive to the product due to the lower risk. This increased our product offerings in our solutions for projects.
- The work required to implement an SSIS project is relatively quick compared to other tools and it reduces the amount of time required by staff to configure.
SSIS has more configuration options and its smooth running GUI (in visual studio) makes implementation easier. It's ability to provide visual programming and allow users to input code for more complex logic and configuration gives users a great degree of flexibility.