Search code examples
sql-serversharepointssisetlssis-2012

loading excel data from sharepoint library to table using ssis

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.

Solution

  • 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