Ignore failed connection/record retrieval and complete the iteration

[desanip]

Hello,

I have a job where it loops through and reads data from 50 tables in a database. I want to know how i can continue processing other tables even i encounter problems with one of the tables and complete the job with a list of failed tables? If you can provide me with an example it would be great.

Thanks everyone.

[Anonymous]

are you using tmssqltablelist or toraclesqllist components?

[desanip]

Hello Manish,

I am using toracleinput to write select statement and pull in records from multiple tables and writing to a delimited file for output.