Are there any SSIS API that I can use with Javascript to retrieve MS Sharepoint .xml file contents?

Octopus 1 Reputation point
2021-10-01T09:04:00.517+00:00

I would like to ask if there is any SSIS API that I could use in my Javascript code to retrieve the contents of the excel files stored in Microsoft Sharepoint. I would like to do two things for the retrieved data: 1. to insert it into the respective tables in Microsoft SQL Server database and 2. to display it in html page for reporting purposes.

Any answer would be very much appreciated. Thank you!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,996 Reputation points
    2021-10-04T06:03:48.887+00:00

    Hi @Octopus .

    With SSIS, we could easily insert Sharepoint data to sql server table.

    Not sure if this could give you some idea for there is only little information about Java with SSIS.

    I'm not familiar with Javascript, I'd like suggest that you may post the issue to Java forum for more professional suggestions.

    Regards,

    Zoe


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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments