Log Table

• Timothy Moore

  SSC Veteran

  Points: 234

  More actions

  April 11, 2007 at 10:05 am

  #123543

  I need to create a log table that will log the following information.

  • File name
  • Inserted Status (Y/N)
  • Date Inserted
  • # of rows inserted
  • start time of insert
  • completed time of insert

  I have never created a log table, so i am wonder how this information is populated from when these files are loaded. anyhelp with first steps or pseudo code would be an amazing amount of help

   

  Cheers

• Steve Jones - SSC Editor

  SSC Guru

  Points: 728164

  More actions

  April 11, 2007 at 11:28 am

  #699870

  How are you loading the data? Typically I'd insert a row on the start and populate the name, "n", date, 0, getdate(), null.

  Then after completion, update the row (based on filename or date or both) with the competion time, rows, etc.

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com

• Bulent Gucuk

  SSCertifiable

  Points: 5279

  More actions

  April 12, 2007 at 7:19 am

  #700047

  Steve is right about how you're loading the data.  If you're using DTS to load I recommend having an execute sql task that populates the fields Steve described and after you the completion create another execute sql task to insert/update the rest of the fields.

  Good day...

  Bulent