We get a csv file every 1 hour into our FTP server and then that file needs to be grabbed and then the data from that file needs to be loaded into multiple SQL tables in a Live database which our users also will be using during that time.
I have the following questions:
1. Will there be any kind of table locking since it will be done to a LIVE database
2. What's the best approach of doing this and how it can be done.