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.

  • sum of time based on flag from multiple rows SQL Server
  • SQL Server converting varbinary to string
  • SQL Server Iterate through CTE
  • Getting General error: 4004 General SQL Server error:
  • SQL Table Foreign Key that is part of a Composite Primary Key
  • SQL Server Table locks in long query - Solution: NoLock?
  • One Solution collect form web for “loading excel data from sharepoint library to table using ssis”

    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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.