I like the Power Query Data Source for SSIS, because with Power Query Desktop you have an intuitive Tool to develop and at the end you only copy the results to SSIS and all the work is done. In most cases.

Today I came across the following message: “The system cannot find the file specified”

It was not the first time this message poped up, when using Web.BroserContents or HTML.Source Power Query Element. The Problem is, that this functions where preview, when the latest version of the Power Query SSIS Component was released. (24.12.2019)

[see also]