ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am new here

Is it possible to validate the data on the input file when doing the import? Incoming data is tab delimited and I want to check for things like valid post codes, valid dates, incoming fields do not exceed a specific length, data present for required fields etc.

If this is possible, what happens on a validation error?
Does the process stop, or skip the record in question and continue with the rest of the incoming data?
Do I get a list of errors in the file?

Thanks,
Conan.

There are a lot of ways Advanced ETL Processor can help you to validate data
For post code you can use regular expressions
For date fields you can use date format
There more than 190 data validation functions

www.dbsoftlab.com/etl-tools/advanced-etl...data-validation.html

Best way to get started with validator is to watch this tutorial

www.dbsoftlab.com/online-tutorials/advan...o-ms-sql-server.html

You can choose what do in case of failure

1. Abort Import
2. Set default value
3. Reject record
4. Write message into log file
5. Discard Record

See attached picture