PASS_Horizontal

SSIS Error – the path for isserverexec.exe cannot be found

Recently been working with getting multiple SQL Instances on one machine to work. When I uninstalled an old one it affected the latest one. Then all of a sudden my ETL jobs failed. It did not make sense at all seeing as I removed a different instance.

Got the following error when trying to run my ETL jobs or when trying to deploy the jobs:
“the path for isserverexec.exe cannot be found”

Looking for solutions online, they recommend going into the registry. Which didn’t work for me.

I ended up using the install file and running it to add features to an existing connection. And there is was Integration services was not installed for the instance that I was getting the error with.

Installed SSIS on the current instance that needed it and all worked perfectly after that and the jobs ran as perusal.

Hope this helps someone else in the future.

PASS_Horizontal

Download And Unzip files using Power BI Desktop and R Script | Prathy’s Blog…

Most of the open data source providers supply data in a compressed format, especially when files are large. That is what I noticed with Company House data. I wanted to explore company house data us…

Source: Download And Unzip files using Power BI Desktop and R Script | Prathy’s Blog…

Power Bi

Push data to Power BI streaming datasets without writing any code using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

Today, I am happy to announce an exciting new update to the Power BI connector for Microsoft Flow. Coming hot on the heels of our data alert Flow trigger, we have added a new action which pushes rows of data to a Power BI streaming dataset.

Source: Push data to Power BI streaming datasets without writing any code using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI