keep accumulate values from an everyday excel sheet

Question

Hello,

How can i keep adding values from an excel file that changes every day in a folder and then present these accumulation in a table in ssms.

in a table in ssms i want to appear the following (yeah this is not an ssms table)

if possible can you guys do a step by step tutorial in SSIS? i am kinda of a newbie in SSIS.

Answer 1

Hi @David Marques ,

The changes you mean is daily change the original data in this excel file, or append data to the file ? Could you share the sample data(columns) in excel file, the table structure and expected results more specifically.
First make sure that the excel file structure corresponds to the SQL Server table. For the data retention in the SQL Server table, whether to append the data in the excel file to the table every day or to retain only the latest data of the day.

Hope following articles will be helpful:
https://learn.microsoft.com/en-us/sql/integration-services/load-data-to-from-excel-with-ssis?view=sql-server-ver15

https://www.wiseowl.co.uk/blog/s231/schedule_data_import_in_sql_server_pt1.htm

---

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.