-
DTS Help (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|