loading excel data from sharepoint library to table using ssis

Question

I have created a library in sharepoint.Inside the library I created sharepoint default columns like doctype,filename,modified,modifiedby,status.

In filename column I have excel doc present.I want to load the excel data from this library to a table using SSIS Package.The number of columns in excel is same as table.

juan · Accepted Answer · 2017-06-28 18:31:27Z

2

If you want to load data from Sharepoint, I'll recommend you to use the Odata Source

Then with the absolute path to the xls, you can use an Excel Source to load your data to a table

answered Jun 28, 2017 at 18:31

juan

1111 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

loading excel data from sharepoint library to table using ssis

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related