I have a requirement where we get data from Oracle source and destination is also Oracle db. Only validation is done in SSIS. So, i have to validate the data using regular expression in SQL Storedprocedure (in ssis) and send bad data to a error log table with logging the record ( with table name , column name , error code) .
I am new to regular expression , i am kind of confused how to start and how to validate with regular expressions.
Can you please provide simple , sample example to understand.
For example : Age validation : Age cannot be zeros , age cannot be 200 years old or in future.
How do we get simple Storedprocedure for the same?
Thanks again for help in advance.
- This topic was modified 1 month, 1 week ago by komal145.