|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-23 : 10:52:04
|
| Howard writes "I posted this to the wrong forum and didn't want to cross-post to the Import/Export and Replication Forum. I am somewhat of a beginner in using DTS. This problem is similiar to the one posted on 10/31/2001 I am having a problem with importing a csv ( a few rows are shown below) using dts into a table from which I need to update another table. The problem is that I need to add the stock from all the whse into one field with the isbn as the key. Then update the other table with stock, discode, and price will update where the isbn exists. I am using SQL7 and need to run the process nightly.The csv has over 1,300,000 rows but I only need to update about 10,000 records.Any suggestions would be appreciated.Howardisbn,whse,stock,backorder,disCode,price0001025252,SOM,1,0,H,9.950001046403,MOM,0,3,H,14.950001047647,MOM,2,0,H,14.950001047647,SOM,3,0,H,14.950001047655,MOM,3,0,H,14.950001047868,MOM,4,0,H,14.950001047868,REN,3,0,H,14.950001047868,SOM,3,0,H,14.950001047973,SOM,1,0,H,14.950001048074,MOM,1,0,H,22.950001048503,SOM,2,0,H,14.950001049143,COM,3,0,H,11.950001049143,MOM,1,5,H,11.950001049143,REN,5,0,H,11.950001049143,SOM,4,0,H,11.950001049283,REN,1,0,H,14.950001049356,COM,1,0,H,14.950001049356,SOM,6,0,H,14.950001049690,MOM,0,1,H,14.950001049690,REN,1,0,H,14.950001050184,REN,1,0,H,14.950001050184,SOM,0,3,H,14.950001050192,MOM,3,0,H,14.950001050494,MOM,1,0,H,14.950001050494,REN,0,1,H,14.950001052012,COM,0,1,H,14.950001052012,SOM,0,1,H,14.95" |
|
Add columns while inserting incremetal updates