Post reply

How to get count of foreach loop and Job statistics?

  • June 2, 2009 at 6:40 pm

    #210474

    Hi,

    I need to get the count of how many files having been processed after a Foreach Loop container and using that number to put into a database table.

    The database table would have the processed_file_count, job_id, fail_or_success, job_duration.

    How do I get those 4 columns' information updated once my SSIS job completes?

    Thanks for any suggestions!

  • June 3, 2009 at 3:51 am

    #1003870

    Shing,

    I think the easiest way is to define 4 user variables, populate/alter them in a script task inside the loop and persist them in the database after finishing the loop with a SQL task.

    WM_JUSTMY2CENTS

    Guenter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply