Write to job log or create own

• Daryl AZ

  Hall of Fame

  Points: 3087

  More actions

  November 2, 2006 at 9:02 am

  #115251

  I am creating a nightly process to refresh data in a datawarehouse. In prior projects I have created a dataPullHistory type of table. In there I would store statistics of the pull as a unit and stats for the smaller steps inside the whole.

  The plan is to run a doall-maestro sproc from within SSIS.

  From a conceptual point of view which is the more attractive:

  1) create a datapullhistory table and populate it within doall sproc (easiest).

  2) create a log file populate from SQL (not hard, however cannot query for stats)

  3) write to job log. aka right click job 'view history'

  4) other...

  On a lighter note: SS2005 TRY CATCH are/is a beautiful thing with dynamic queries.

  thanks

  Daryl

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 2, 2006 at 3:47 pm

  #669647

  If you plan to query that table I vote for 1

  
  * Noel