Compare tab delimited text file with table field.aize
Posted on 2011-03-20
I need to compare the field length in a text file with that of the required field size in its destination table. If any of the fields are to long, I would like to create a report (can be an export to excel) that details which row the error occured on. If there are no errors, I append the data to the table. All the fields are text data type.
EXAMPLE - Field1 has a value of" A01E36" but the field size limit is 5, this record would be on the report.
I am creating a staging table in DB1, but the destination table would be in a remote DB.