Export SQL table to Excel in Sharepoint

forresto 1 Reputation point
2022-10-07T20:39:00.863+00:00

Reading from Sharepoint into SQL is a completed task.
Writing from an SQL table to an Excel file in Sharepoint is something I am stuck on.
I do have restrictions so using Reporting Services is likely not going to work.
Purchasing a an $800/yr license is something I can't sell.
Perhaps importing from SQL to PowerBI then out to Sharepoint is an option I have.

This person here is doing it but I do not know how.
https://learn.microsoft.com/en-us/answers/questions/300862/ssis-package-writing-to-excel-file-in-sharepoint.html

How do I use SSIS to write an Excel file on Sharepont?

thank you : - )

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,466 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,707 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points
    2022-10-10T05:31:01.68+00:00

    Hi @forresto ,

    From the link you provided, it seems that he is using share folder to access the file such as \sharepoint\folder\file.xlsx.

    I'm not familiar with SP, please have a check that you could also access the UNC path with SSIS and then you may load data to the excel on Sharepoint.

    If this do not work, please consider downloading the excel file from SP first and then re-write and upload to SP.

    This could also be done from SSIS.

    https://www.techbrothersit.com/2016/07/how-to-download-file-from-sharepoint-by.html

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.