One Star

Skip exception on tMysqlInput component

I am trying to skip the exception on tMysqlInput component. My Query is simple like
"SELECT "+row10.sid+" ,"+row10.qid+" ,"+row10.parent_qid+" ,"+row10.gid+" ,
"+row10.survey_table+"."+row10.survey_title+" as response,id as response_id
FROM "+row10.survey_table
Here row10.survey_table is a dynamic which depends on sid, it may exists to some or may not to some ID's.
My intention is to skip the exception when row10.table_1 is not existing.
Please find my Job
1 REPLY
Seventeen Stars

Re: Skip exception on tMysqlInput component

I would check if the table exists before. MySQL provides and information schema for every database. I would dig in these tables to get the information if the table exists.