Microsoft Power Automate vs. SQL Server Integration Services

We replaced all the classic SharePoint and Nintex-based workflows with Power Automate. This saved extra licensing costs and getaways from managing legacy workflows. Power Automate Designer is very user-friendly and requires no additional learning curve. We also use it to replace RPA solutions created with other platforms using the Power Automate Desktop application.

Incentivized

Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.

Incentivized

• Sending confirmation email to clients and user once the flow is triggered.
• Fetching or Dumping files from one location to another if the flow is triggered.
• Schedule flow helps to send alerts and triggers the flow at a specific interval of time to carry out the required task.
• Power Automate also be used to convert any file format to a specific file format and save it to the required location

Incentivized

• SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
• It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
• When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.

Incentivized

• No activity disable feature in the workflow, this would have saved lot of time
• Allow turn off feature to not trigger any pending runs in the queue or add new feature to just run pending runs when the workflow is turned off
• Allow easy copy and paste activities from UI

Incentivized

• SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
• SSIS is not available on any environment other than Microsoft Windows
• SSIS does not function with any database engine back-end other than Microsoft SQL Server

Incentivized

Power Automate is a great product that has a vast array of options on how to use it. Your imagination is the only hurdle with using Power Automate as there is no limit to what can be done with the system. It has brought a lot of value to our business through the use of custom systems, connectors, and streamlining processes.

Incentivized

SSIS is responsible for running core business processed managing core business data. It can be managed, improved and expanded using minimal internal resources. It is also able to support all of our current data infrastructure. Replacing SSIS would be time consuming and costly with no apparent ROI.

Incentivized

For most tasks WinAutomation is great and easy to use. You just set up tasks on a step by step basis and you can even tell the program what to do when there is an error (such as continue with job). Sometimes with complicated web extraction jobs it would be good to be able to easily extract data from the web page source.

Incentivized

SSIS has a drag and drop based developer interface, so it is relatively straight forward to get started. You can start to get into the weeds pretty quickly as your solution becomes more complex. However, most of the base functions are right in front of you for a developer. You can also set project and solution level parameters, so when you deploy to new environments, you don't have to jump into each package to change your variables and settings. (For example, default directory to ingest flat files).

Incentivized

Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.

Incentivized

both Community support and Microsoft official support typically respond to (and resolve) reported issues in a VERY expedient manner, usually going above and beyond for education and bugfixing. I have been thoroughly impressed with the level of support I had been provided in the past.

Incentivized

The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

Incentivized

after reviewing the main features of Power Automate, the Microsoft trainer focused on some of our real life use cases implementation, from simple to more advanced.

Incentivized

although it was productive, it is more difficult to stay focused and in a 7 hours a day online training (including screen share issues and the fact that the trainer just can't precisely show the exact location of your mistake)

Incentivized

I had to migrate from Robocorp to Power Automate. The automation was using API and sharepoint. So it was better to use Power Automate instead of Robocorp so we did the migration. in some areas the migration was easy but creating flows and making it smaller codes was difficult. Debugging the code was tough so we took lots of time.

Incentivized

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

Incentivized

Power Automate can do many things that most platforms can't do as a 'citizen-developer' with no access to coding tools and deployment. It allows you to develop and deploy low/no-cost automation flows quickly. The blocks in Powert Automate do the API work for you, where you only need to connect the key data points and actions taken.

Incentivized

I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer

Incentivized

• Automating emails for finance and payroll has not only saved hours of work for those departments but lowers the risk of human error.
• Creating workflows and approvals for our goals and bonus system has saved everyone in the organization hours of manual work and MATH!

Incentivized

• Without this, we would have to manually update a spreadsheet of our SQL Server inventory
• We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
• We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.

Incentivized