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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sqlserverdeveloper
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??
Thanks!!

You are not authorized to post a reply.

Acceptable Use Policy