How to Output SQL Query result into Sharepoint?

Question

Hi all,

I have a stored procedure that converts binary data into pictures and outputs the JPEG files onto the disk drives. Unfortunately, there isn't enough space on the drives and I would like to utilize a web location like SharePoint or Azure.

Sharepoint is the first option at my disposal and I want to directly output these contents with or without a middleman (like PowerAutomate). How can I achieve this providing access/gateway issues are out of the way.

SQL Execution script is like this;

EXEC @return_value = [dbo].[ConvertImageFiles]

       @ImageFolderPath = N'E:\PictureExports

I changed the destination path to my SharePoint folder and nothing is happening

Any help guys? Thanks

Answer 1

I guess this procedure uses xp_cmdshell + BCP for the export. Keep in mind that driver letters etc are those of the service account for SQL Server, not yours. And the service account is unlikely to have access to Sharepoint.

Overall, I can't say that I am fond of solutions where you write to disk from SQL Server. It is much better in my opinion to use a client-side program for the task. That could be PowerShell, C# or whatever you like. This will save you from the limitations you are running into now.