August 22, 2001 at 8:37 pm
I've been trying to setup a process that will take a flatfile and the max(id) from a sql server db table to load into target sql server db table. After playing with number of different objects (File Source connection, db connection, Data-Driven Process, etc.). I'm not sure what object, process should be used to perform this task?
help and thanks
Carlton
August 22, 2001 at 10:11 pm
If this is SQL 2000, you probably want the dynamic properties task. You can use teh results of a query to alter the data xfr task.
Steve Jones
August 23, 2001 at 8:41 am
Out of luck for me, this is on SQL Server 7?
August 23, 2001 at 10:46 am
Can you upload into a temp table and then do a join to insert into the real table?
Steve Jones
August 23, 2001 at 4:00 pm
Creating the temp table makes sense to me. Depending on the type of process, you might want to then add it to some type of history table anyway.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply