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. Any ideas?? Thanks!!