SSIS Package Import Excel Data

I have created an SSIS package to import an excel spreadsheet into our reporting server. As it stands now, the package will add all the rows to the table, not just the new rows since the last update. How would I update this package to only update the table with new rows since last update?
dplowmanAsked:
Who is Participating?
 
PedroCGDCommented:
no...
After your source, add the lookup... inside lookup you need to add the referenced table that you need to check if the record exist or not.
If exist you should udpate or ignore, correct? If not exist insert new record, correct?
Take a look at the following image:
 LookUP
0
 
PedroCGDCommented:
In the SSIS package, inside dataflow, add a LOOKUP component to check if each row already exists in destination.
Helped?
regards,
pedro
0
 
dplowmanAuthor Commented:
Do I enter the lookup component between the excel source and OLE DB Destination? This is my first time createing a package, so my knowledge is very limited.
0
 
dplowmanAuthor Commented:
Thanks, much appreciated!
0
 
PedroCGDCommented:
Very good!!
Always welcome! :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.