I'm looking for a solution for the below situations,
1 When the source file/table not available in the specified folder I need to stop the execution of my script and the script should stop the ETL work flow/Job automatically.
2 When the source file/table contains error data say, the source table contains 20 records among which 5 contains error data. I need to have a script in place which will remind me that only 15 records were processed and 5 were excluded for error table. In this scenario I need to send an email to the customer with the complete details automatically.
3 Once the Errored data was corrected and placed in a source location I need pick that table/file and need to carry the required process to create a stage table. Once the stage table creation was done which should trigger the ETL work flow automatically.
4 Once the Stage table created, I need to archive the source table automatically.
Please share me your Ideas will these can be achieved else I need to rely on my ETL tool?
Thanks In advance.
asked 03 May '12, 09:22