Importing data into multiple sql tables from a single file

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  June 27, 2008 at 9:44 am

  #71623

  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!!

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 27, 2008 at 3:26 pm

  #835648

  1. Table-locking? that depends on how you do it.

  2. Best way: that depends a lot of the FTP files format/layout. Please post that plus some sample data.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]