question

Octopus-3430 avatar image
0 Votes"
Octopus-3430 asked WendyLi-MSFT edited

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

In what environment is your JavaScript code executing?

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @Octopus-3430.

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.