Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logging in SSIS package

Status
Not open for further replies.

tirf

Programmer
Sep 22, 2008
59
US
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,

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top