SSIS Data Flow Components Reviews

the most i like is execute process task which can run command prompt commands

new connectors and being microsoft specifc.

API Integration via third party softwares like zappysys

ftp and sftp integration

data integration

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

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

Moving data from point a to point b is very fast, it is an in-house tool of Microsoft which works very well with sql server

The components are intuitive and easy to use.

The IDE crashes on rare on some occasions.

We are able to get our SSIS packages developed and deployed in a much more timely manner,

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.

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.

ETL designing is super easy with this product. Maintaining historical data is really beneficial to any organization. Deployment and maintenance is not an overhead.

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

Some times the ssis gives hang issue due to memory constrainst and we have to restart the solution

Good

We are using ssis data flow to load data from Hadoop to SQL database which is then used for dimentional modelling.

The ease of moving data from multiple sources to SQL Server given the amount of transformations that are all possible to implement within SSIS

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

The business problems it is solving is moving data into our data warehouse. We exclusively use SSIS and the Data Flow Task to move data from our source systems into our warehouse

The ability to handle large volumes of data efficiently.

SSIS provides a wide range of source , transformation and destination components.

Also, it has robust error handling capabilities

And its ability to integrate with other Microsoft technologies like SQL server databases, Azure services and more.

It has limited cross platform support - SSIS is primarily designed for integration with Microsoft technologies and its native components might not be as well suited for cross platform integration with non Microsoft systems

Also, debugging SSIS packages can be complex, especially when dealing with intricate data flow logic or when errors occur in larger packages.

SSIS provides a robust platform for designing and executing ETL processes, facilitating seamless integration and transformation of data from various sources

SSIS automates ETL processes, reducing manual intervention, minimizing errors and improving efficiency in data integration tasks

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.

- 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.

My current processes are editing very complex XLS spreadsheets to build datasets of clients to send to a bulk mailer web app. By doing this with SSIS I can automate this and make a task that takes hours and is very error-prone run instantly.

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.

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.

It's a great tool to collect data from variety of sources.

1) It helps to collect data from variety of sources. Like, Excel,SQL,csv,XML etc.

2) it's easy to use this. User can perform some complex task with drag and drop.

3) it's easy to customise or modify existing SSIS packages.