package looging for SSIS Package

• Jay Pete

  SSCommitted

  Points: 1945

  More actions

  May 24, 2012 at 9:04 am

  #258628

  Hi All,

  I have SSIS package which loads the millions of data everyday.SSIS package has Flatfile Souce and OLEDB Destination.I want logging so i should have records how many records are inserted into the table.

  Please suggest to get rid of the task.

  Thanks in advance,

  Jay

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  May 24, 2012 at 12:24 pm

  #1492717

  Take a look at some of these blog posts for some ideas:

  http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

  http://amenjonathan.wordpress.com/2010/11/14/creating-a-solid-ssis-etl-solution-part-1-package-and-error-logging/

  http://www.thejoyofcode.com/SSIS_Custom_Logging_Task_for_Event_Handlers.aspx

  HTH,

  Rob

• kiro72

  SSC Rookie

  Points: 49

  More actions

  May 24, 2012 at 12:26 pm

  #1492718

  Short answer -- Use a bulk load, cuts the log dramatically

• Jay Pete

  SSCommitted

  Points: 1945

  More actions

  May 24, 2012 at 12:37 pm

  #1492725

  kiro72 (5/24/2012)

  ---

  Short answer -- Use a bulk load, cuts the log dramatically

  What should i consider this one..is this joke?