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.

  • substring of variable length
  • Stored procedure problem in MS Access caused by ReturnsRecords (accdb)
  • Convert XML to table in SQL Server 2005
  • Executing an SQL command with EntityManager
  • SSIS how to redirect the rows in OLEDB Destination when the fast load option is turned on and maximum insert commit size set to zero
  • Using Import wizard to import Excel data into table in SQL Server 2012 failing - text truncation
  • 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.