SQL server will not fetch data SFTP

stino123 · ‎02-10-2022

Hey All,

This may sound very silly but at my current job data is fetched from an SQL server that I believe runs a script to fetch data from a third party SFTP. The person who worked on the power bi as well as the person who I believe created the script both do not work here anymore. There is no one who has the information and now the data is not refreshing.

On the SFTP server I can see the data is refreshed on 10/02 however on the SQL server the last data is 02/02. This leads me to believe that there is something wrong with the script. Does someone know how to see the script or have another solution?

Thanks in advance!

lbendlin · ‎02-12-2022

Your problem doesn't seem to be Power BI related. Is there a SSIS package running on the SQL server, or how else does it get the data from the SFTP source?