Automate Data Import from Excel to SQL server using Sql server agent
$10-30 USD
Completed
Posted almost 8 years ago
$10-30 USD
Paid on delivery
An excel file has some data for current month which is received everyday from other person.
We need to delete existing month data from the sql server and import the data in the excel file on the server. The columns are exactly same in both excel file and sql server
Create a package in SSIS and schedule a job in sql server agent to run this package of importing data from excel to sql server everyday.