Charles Baldo
asked on
Flat file to Insert Update
Hi I have a flat file of 400,000 records.
I have an existing table that matches the flat file. This wil be the second time I read the data in. The first time the table was empty. This time the table is full and about 10% of the fields will be new, 10% will need to be update. How can I read through the flat file and decide if the key already exists. If it does I want to update the table if it does not I want to insert the data into the table. I do not know ahead of time which frows will have changes data so if I need to do every record that exists and update it thats ok.
This is a once every quarter update speed is not an issue.
I have an existing table that matches the flat file. This wil be the second time I read the data in. The first time the table was empty. This time the table is full and about 10% of the fields will be new, 10% will need to be update. How can I read through the flat file and decide if the key already exists. If it does I want to update the table if it does not I want to insert the data into the table. I do not know ahead of time which frows will have changes data so if I need to do every record that exists and update it thats ok.
This is a once every quarter update speed is not an issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You all I did give an excellent grade because I appreciate the quick response. However the solution was only a partial.
ASKER
I understand its difficult to know exactly what the issue is and whats in a programmers mind. But ocassional it happens. Below is a link of almost exactly my issue and it was solved. The steps suggested by the experts were used. Thank both I will split the points.
http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx