HomeForum
Welcome, Guest

Add New and Update Old Records problem
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Add New and Update Old Records problem

Add New and Update Old Records problem 1 year, 2 months ago #2187

  • NewUser
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Good afternoon,

I downloaded your trial version of Visual Importer ETL. I created a job to
transfer data from one DB to another. I have the "Transformation Type" set
to "Add New and Update Old Records".

The problem I'm having is that when I run the job, is only "Updating"
records and NOT inserting new ones. There are at least 10 new records the
job should of picked up, but it did not. Is only doing updates.

I also tried changing the transformation type to "Add New Records" to see if
that would pick up new records only, but it did not.

Can you provide some guidance please. Thank you.

NU

Re: Add New and Update Old Records problem 1 year, 2 months ago #2188

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Hi.

What is your target database?
Have you specified update key?
Can you email us your log file?

Peter

Re: Add New and Update Old Records problem 1 year, 2 months ago #2189

  • NewUser
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
What is your target database? MySQL (Source: FoxPro)
Have you specified update key? Yes
I can but there are no errors, warnings,etc on log file.

NU

Re: Add New and Update Old Records problem 1 year, 2 months ago #2190

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Hello.

I can confirm that there is a problem with loading data into MySql database.
It is rather complicated issue and will take couple of days to resolve
Once it is resolved we will inform you

Best regards,
Mike

Re: Add New and Update Old Records problem 1 year, 2 months ago #2191

  • NewUser
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Thank you. We’ll stand by on the new release with this fix. Once fix available, we will download and finish the evaluation of your product. We are looking to make a purchase of an ETL like tool within the next week or so. Thank you.
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"Advanced ETL Processor is superior software... I highly recommend this to anyone who is building datawarehouse. I would and I  have recommended it to many colleagues and customers."

- Peter Jonson, Data Integration Consultant, MPI

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top