File System Task > Audit / logging

• chrismgarvey

  SSC Eights!

  Points: 834

  More actions

  February 5, 2010 at 2:57 pm

  #138077

  Hi All,

  I am using a foreach loop container with a file system task, to move files before loading into a Database.

  The file system task is performing a "move" command.

  Is it possible to somehow log to a table:

  1) How many files the loop container finds at the source location?

  2) How many files are moved to the destination location?

  Many thanks in advance for your advice and suggestions.

  Regards,

  Chris

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 8, 2010 at 12:56 am

  #1115315

  Create a record using an Execute SQL Task (SQL) before starting your Foreach Loop Container (FEA) with two columns = 0.

  Update the record with an SQL at the beginning of your FEA to increment the the first column by 1.

  Add a precedence constraints to you File System Task: in case of success, update the second column by 1.

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]