Hi Da-zero, you're very right. I could be a possible bottleneck in the future, so it stays a 'issue' to solve right.

For the moment i choose this solution cause there...

Hi da-zero,

Thanks for your reply, the update will be on less than 1000 records per day, so performance (at night) isn't all of a issue. I have solved it by...

Hello Alvin,

thank you for your reply, I do use the right procedure 😉 It should be fired for all records changed (all) .

🙂

Regards,

Peter

Hi Alvin,

I have implemented a multicast, but the strangest thing happens.

I have PK in the destination table, I have cleand the input from double data, but yet still (after...

Hi alvin, sounds like it's going to be a bit towards the solution of my problem 🙂 I will try it immediately..

thank you,

Peter

Hello Graig,

Sorry if i didn't made myself clear. I try to explain a little more and better 😉

I have a flatfile import

this import goes into the table 'staging'

The columnnames...

thanks derek, for the quick response and answer. I give it a try immediately and will let you know.

Peter

Hello alvin,

Thank you very much for your reply.

I let you know the results.

Peter

Hello Wayne,

Thank you for the clear explanation. I will try it immediatly and will let you know the results.

Thanks again!!

Peter

hello Wayne,

Thank you for your reply.

I indeed can get the supplierId from the filename, but I cant figure it out to use it as a variable and insert it as...

Not anyone a hint or tip 😉 ??

Hello alvin,

Thank you for your reply.

I would like to use a part of the filename (there is the supplier ID) into the extra column for the import, but I dont...