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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy