Need a solution to validate multiple column's data of flat file source based on a db table data.

hi all,

i trying find solution task.

my task is, have flat file source data using flat file source of dft, reading it. 

now have validate data of source each row on columns data of different tables of database.

for example, data of columna of source file need validate x table data of database. in same way data of columnb of source need validate y table data of database.

what want is, each column of source data, have apply different business rules , after passing these validation result data have insert destination table.

please me, if 1 have solution this.

thanks & regards

ashok vallu  

hi ashok,

it depends on number of column want compare. if rows less can use lookup transformation compare it.

while using lookup component cautious selecting appropriate modes(full/partial/no cache).

thanks

aravind

SQL Server  >  SQL Server Data Tools