how to update data in table while importing from csv using SSIS?

Question

0.00/5 (No votes)

See more:

i have a csv file from which i have to store data to my table[USERS].
this file is generated daily with some updates to records of user details.
i have done importing part quite well but every time i run this project it INSERTS whole data over again instead of just UPDATE.

say the csv file for day 1 is

1,sushil,sainju,sushil@gmail.com
2,subash,stha,subash@gmail.com
this file is imported to the table quite well but when i run this project after making few updates to the csv file
say
1,sushil,sainju,sushil@gmail.com
2,subash,aaaa,SHAK@hotmail.com

the project will add 2 more records to the table instead of updating the existing records. can anyone pls help me with this?
thanks in advance.:)

Posted 10-Oct-11 1:43am

sushil sainju

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

André Kraak · Answer 1 · 2011-10-10T10:23:00

Define what makes a line (record) unique, for example the number at the beginning of the line. To make sure that the table only excepts unique numbers define the number field as the primary key of your table.

Then use this number to search for it in the table. If it exists update the record with the information from the file. If it does not exist insert a new record in the table.