Load data to multiple SQL tables from a single File

Last Post 27 Jun 2008 11:48 AM by sqlserverdeveloper. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Jun 2008 11:48 AM
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??

Acceptable Use Policy