
Robust data integration and user friendly interface Review collected by and hosted on G2.com.
Limited support for real time data and challenging during debugging Review collected by and hosted on G2.com.
-Ease of use :- Its a simple drag and drop tool whichbis very easy to use.
-Good customer support:- Being offered by Microsoft it provides good customer support Review collected by and hosted on G2.com.
-It gets slow sometimes when data size begins to increase.
-Sometimes it is difficult to find articles for its issues' resolution.
-Edit option functionality breaks sometimes Review collected by and hosted on G2.com.
It's a great tool to create the ETL pipeline and deploy it to the SQL server integration services. I have been using it from last 10 years. Review collected by and hosted on G2.com.
Limited Integration with Web API and cloud computing databases. Review collected by and hosted on G2.com.
The drag-and-drop interface and components make data transfer easier. Review collected by and hosted on G2.com.
Wish that there were more plug-ins built in out of the box instead of having to search for additional integrations. Review collected by and hosted on G2.com.
The product is integrated with Visual Studio / BIDS really well, looks and feels like a standard feature, not something you install on top of the other products. It's simple and easy to use for most ETL tasks. The documentation is available and understandable, and the community support is decent. Review collected by and hosted on G2.com.
As the ETL task gets more complex and advanced, you use different approaches to use the tool to utilise it's flexibility, but this makes the tool and its usage harder to document and understand for other developers. Review collected by and hosted on G2.com.
SSIS is easy to integrate with most popular databases such as SSMS ans Oracle Review collected by and hosted on G2.com.
SSIS is not supporting Master Data Management feature at this point Review collected by and hosted on G2.com.
SSIS integration tool is an alternative for low code no code approach to connect to external data sources such as Dynamics CRM to fetch data and migrate it to SQL Server. Writing C#sharp code to connect to source is been replaced which reduced man power and execution time. Review collected by and hosted on G2.com.
Sometimes it mask the error. For eg error was for user not been added in azure, but it was showing as incorrect string format which was very difficult to decode. Review collected by and hosted on G2.com.
user can integrate MS dynamics 365 with any other app or data system.
it supports NAV, CDS, AX etc.
it has simple development environment Review collected by and hosted on G2.com.
Needs some expertise to work on it and may take a while to learn Review collected by and hosted on G2.com.
SSIS is best data migration and integration tool, it can extract and transform data from multiple relational databases, also able to fetch data from XML and flat files like notepad etc. My overall experience with SSIS is too good, its reduce processing time as well as increase efficiency and productivity. Review collected by and hosted on G2.com.
If we run 5 to 6 packages parallel its consume 95% resources of CPU, moreover SSIS mainly Microsoft centric Review collected by and hosted on G2.com.