We help IT Professionals succeed at work.

SSIS data lookup

SamRunyon
SamRunyon asked
on
600 Views
Last Modified: 2013-11-10
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
Comment
Watch Question

Commented:
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

Author

Commented:
Pedro, what would the SSIS layout look like?

Sam

Commented:
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?

Author

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
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
Any improvements? Need more assistance?
If not set this question as answered.
Thanks,
Pedro
www.pedrocgd.blogspot.com
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.