Hi,
We have an Excel sheet with product number and the new product description.
A product table in our DB has old product description. So I want to update it with the Excel sheets data of new product description.
So, what I do now is I bring the Excel sheet into SQL server DB as another table, and join it with product table on product number as key, and I run update scripts to update the description.
Now I want to automate it on a regular basis, like whenever we get a new Excel sheet; then we should just run a job and it should be done.
We can always keep the name of Excel sheet, columns as same so that it runs properly every time.
How can I achieve this by SQL server agent/SSIS?
ANY help?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP