the most i like is execute process task which can run command prompt commands Review collected by and hosted on G2.com.
new connectors and being microsoft specifc. Review collected by and hosted on G2.com.
I love their flexibility in designing and managing ETL processes. Review collected by and hosted on G2.com.
The learning curve was a bit steep and also sometimes I struggled with using them in intricate data integration scenarios. Review collected by and hosted on G2.com.
The best part in data flow components that we have different different templates to use and Crete data pipeline Review collected by and hosted on G2.com.
There is not much more to dislike about this but it's little bit costly to use . Review collected by and hosted on G2.com.
This uses the popular Visual Studio app to build your own structure to push data into the server. For the most part, I'm not writing code but joining up boxes to produce a workflow of one type of data, any necessary changes, to the final target source of data. Review collected by and hosted on G2.com.
- Its fiddly to set up. I now realise you have to install SQL Server Data Tools, which is a plug-in on top of Visual Studio. As my work PC which connects to an Azure VM, I have built a lab to try it at home on my own PC.
- I seem to have two versions of VS installed, and it only works on 2017 not 2019. Sometimes when opening my packages, side menus are missing, looking through drop-down menus doesn't show the correct ones. Instead opening the .SLN fie from the desktop then means it works all ok. The Error box at the bottom sometimes is missing, and sometimes my scripts don't work, and there is less detailed information which can be hard to pinpoint what's wrong.
- I'm trying to build a workflow of data that I want my non-technical colleagues to run when I am not there, so still getting the hang of it. For the most part, it's great, still a lot to learn. Review collected by and hosted on G2.com.
The data flow components is easy to use, it is an drag and drop tool which has so many features and in house tools which makes a developer job quite easy and productive Review collected by and hosted on G2.com.
Complex transformations and some tools like sort, merge etc hinders performance which is a drawback. So typically we call a stored procedure as a mitigation Review collected by and hosted on G2.com.
1) The drag and drop feature of SSIS is easy and intuitive for the desired functionality.
2) The templates like SCD are easy to configure and use to do a lot of heavy work.
3) The runtime debugging is a great feature and helps to find issues in complex scenario.
4) the event handler feature is of great use. User can raise custom events for a specific action.
5) It also provide data transformations. These transformations help to change data as per requirement. Review collected by and hosted on G2.com.
1) SSIS do not provide performance optimisation tools. Most of activities took place behind the scenes. So, user is required to do some heavy work to do fix performance issues.
2) SSIS do not provide debugging at its core level. Like user can see the results of a procedure at runtime. But, it do not show internal debugging of stored procedure.
3) SSIS do not provide enough templates. I think SSIS should provide basic template with multiple components and user should be able to configure them as per available/required resources. Review collected by and hosted on G2.com.
Making connections is easy with SSIS. You can track execution activity by just looking at data flow task progress. When converting source components to destination data types, the SSIS makes it super easy and takes care of metadata issues and synchronization on its own. All in all a very useful product for ETL design. Review collected by and hosted on G2.com.
The product should have advanced mechanisms of error logging. If the container fails, the only way by which one can tell is by looking at error list output at the end of horizontal menu. The product should have capability of running enterprise level of jobs and monitor all jobs in a single screen just like Control-M. Review collected by and hosted on G2.com.
Ssis is very easy to use.
This etl tool can connect to multiple datasources and load data to multiple type of detinations like csv,Excel,database etc Review collected by and hosted on G2.com.
Some times the ssis gives hang issue due to memory constrainst and we have to restart the solution Review collected by and hosted on G2.com.
The ease of moving data from multiple sources to SQL Server given the amount of transformations that are all possible to implement within SSIS Review collected by and hosted on G2.com.
The clunky feel of the source wizard. I also would like to use something with a little more flexibility when interacting with MS Excel as well as MS Access Review collected by and hosted on G2.com.