Add New and Update Old Records

More
12 years 4 months ago #2711 by Greg
Hello

For some reason my update is not working.
When I try and update a file with 767 records it updates all the fields with the last record in the file.
Source is text and writer is access table.
Any ideas?

Thanks,
Greg

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #2712 by admin
Greg

Have you selected update key?

Page 91 of documentation

Also watch this tutorial

www.dbsoftlab.com/online-tutorials/advan...d-etl-processor.html

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #2713 by Greg
Thanks for looking at this. This is a great tool and I'm trying to learn how to use it better so I can spread the word.

I want to update three fields, one being a key but not designated a key within the Access table. I don't see a tutorial on this page just two screen shots?

Thanks,
Greg

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #2714 by admin
Greg

You are one click away form the solution

Have a look at attached screen-shot,
Peter

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.