I have a package which extracts data from Access database to sql server
I have one dataflow task which extacts data to 20 different tables (20 data flows)
I want to create a log file where each data flows log their status after their run (each data flow logs to the same log file) in the following form
======
customer table
. run time - 05/10/2010
. count of source data - 280
. count of destination data - 280
=====
employee table
. run time - 05/10/2010
. count of source data - 1002
. count of destination data - 1002
=====
so that we later examin the log later
any idea how we can implement this
Thanks,
I have one dataflow task which extacts data to 20 different tables (20 data flows)
I want to create a log file where each data flows log their status after their run (each data flow logs to the same log file) in the following form
======
customer table
. run time - 05/10/2010
. count of source data - 280
. count of destination data - 280
=====
employee table
. run time - 05/10/2010
. count of source data - 1002
. count of destination data - 1002
=====
so that we later examin the log later
any idea how we can implement this
Thanks,