I have the various log tables in sql server.I need to insert values of these tables during runtime by using custom log.How to achieve this.Thanks for your help.
You should be able to cause your package to write out anything you want to the log using script and the DTS.Events.Firexxx methods (i.e. FireError, FireInformation, FireCustom, etc.)