Check data within flat file before importing to database 1

[DCSage]

Hello.

I have a package that imports data from a flat file source to a sql server destination. I want to check to data to determine if the record already exists before importing. Is there a way to do this in my package? For example, there are 2 columns main: program and programming code and I want to check the programming code within the flat file to see if the record already exists. Can someone point me in the direction? Is there a tool to allow me to do this in SSIS? Or is it best to create a trigger? If I create a trigger, is it possible on something that has not even been inserted yet?

Thanks in advance.

 

[pjw001]

I would suggest you create a table consisting of a large enough character field to take each record from the flat file, load the data into that table. You can now do whatever you want with sql statements.

 

[DCSage]

Thank you. I actually considered that as my altrnative.