SSIS data lookup

I have a SSIS that is importing a CSV file into a DB.
The SSIS I have it also looking at the file to see if the there any changes.
All this works.

But the problem is I need it to delete the ROW in the DB and insert the the new row with the updated data.

The DATE is the import thing I would like the SSIS to update any row that has data change.

thanks,
Sam

lookup-screen.jpg
SamRunyonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PedroCGDConnect With a Mentor Commented:
follow as you as doing but use only the red line output and replace SQL Server destination by a OLEDB command to update destination with new values... helped?
0
 
PedroCGDCommented:
You are trying to delete and insert. why not only update the rows with new data?!

To update you should use OLEDB Command component!!

Helped?
regards,
Pedro
www.pedrocgd.blogspot.com
0
 
SamRunyonAuthor Commented:
Pedro, what would the SSIS layout look like?

Sam
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
PedroCGDCommented:
re-think your goal...
the goal is:
to look for data that is not in destination?
or to check the rows that need to be updated in destination?

0
 
SamRunyonAuthor Commented:
Pedro, the way I read your message I want to do both.

I want it to import data that is not in the DB.
Then when the job runs again.
Import new data rows and then check to if the import has any data change.
Then update that data change.

I hope you can understand :)

Sam
0
 
PedroCGDCommented:
Any improvements? Need more assistance?
If not set this question as answered.
Thanks,
Pedro
www.pedrocgd.blogspot.com
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.