I am importing records from a flat file to a database table. If a record is in the table but NOT in the flat file, I need to update a date column in the table.
Any ideas
I am importing records from a flat file to a database table. If a record is in the table but NOT in the flat file, I need to update a date column in the table.
Any ideas
Thanks Phil, I read that post before asking my question.
Since the row exists in the table but NOT in the flat file, a lookup doesn't work. Unless you know of a way to connect a Lookup to a flat file. As I mentioned, I need to know when a row in the database doesn't exist in a flat file.
Thanks again Phil.
I seemed to have accomplished the same thing by using a Merge Join setup as a left outer join.
Do you see any performance advantages to using the staging table with a lookup instead
skaszyk wrote:
Thanks again Phil.
I seemed to have accomplished the same thing by using a Merge Join setup as a left outer join.
Do you see any performance advantages to using the staging table with a lookup instead
dear friend,
In my opinion, you can do that using a MERGE JOIN.
Add 2 sources, one OLEDB Datasource in order to get all the IDs, and a second to get the records from flatfile.
Add a merge join and configure it as right or left join depend on the sources order.
Helped
Regards!
PedroCGD wrote:
dear friend,
In my opinion, you can do that using a MERGE JOIN.
Add 2 sources, one OLEDB Datasource in order to get all the IDs, and a second to get the records from flatfile.
Add a merge join and configure it as right or left join depend on the sources order.
Helped
Regards!
Sorry phil, but my page wasn't refreshed and didn't see some posts...
Regards!