Can you give me the examples.
I created the new dts (DDQT) and I have no idea how to compare the fields and the correct way to write the update and insert based on the compare.
Thanks in advance


------------
WizKid at 10/31/01 11:40:24 AM

Try DTS using Data Driven Query Task (DDQT).
I'm not familiar with AS400, but if it is from SQL to SQL I would create a stored proc on my destination SQL server and use it in DDQT. If you have a similar facility to create a custom proc in AS400, you might be able to use it.

good luck..


------------
Sardinka at 10/30/01 10:46:02 AM

I am transfering the data between the SQL tableand AS400 table. I am using the ActiveX script to transfer the data. The table in SQL have no primary key, but the table in AS400 have a primary key. I need the examples how to handle this. The basic rules are:
If the primary key is exist->Update
If the primary key is not found ->Insert.
Please help me.
Thanks