Automate Data Import from Excel to SQL server using Sql server agent
Project details
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.
Skills: Microsoft SQL Server
Awarded to:
Vinay S.
(4.7)
Project budget: $30 USD
budget limits: $10-30 USD
number of bids:
average bids:
Awarded to:
Vinay S.
(4.7)
Project budget: $30 USD
budget limits: $10-30 USD
number of bids:
average bids:
Project details
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.
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.
Skills: Microsoft SQL Server
