I’ve a power automate that gets file contents from an SFTP site and then inserts to an on premise sql server via sql insert row (the file contents are inserted into a blob field). It does seem to work (sometimes). Seems to have something to do with larger file sizes. For a file that is 1.8 MB it takes about 14 seconds. However, if I bump the file size up to 3.7 MB it runs for ever, I’ve stopped it a few times after its still been processing 20+ minutes. Suggestions?
I believe I found the issue, the request size limit is 2MB through on-premises SQL server.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
33
Share
Report
All responses (
Answers (
