SQL server will not fetch data SFTP

[stino123]

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]

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?