Post reply

DTS to update records?

  • March 9, 2004 at 1:01 pm

    #59655

    I have used DTS to create tables and load new records.

    How can I configure DTS to update and/or insert records going forward?

     

  • March 9, 2004 at 1:58 pm

    #498054

    You can just use a data pump to bring the data in from whatever source it's coming from, be it a text file or spreadsheet or whatever else. I would bring the data into a temp table first if you are going to be updating records, then do a join against the data sets for the update usng a stored proc executed through the dts.


    Shamless self promotion - read my blog http://sirsql.net

  • March 11, 2004 at 11:16 am

    #498339

    Thanks for the feedback, this looks like the way I will go....can you provide a quick sample of doing the join in a stored proc...also how to create the proc would be appreciated...thanks again....

  • August 28, 2004 at 9:33 pm

    #520986

    Hi, Richard,

    Did anyone ever provide a quick sample for you, if so, can you share it?

    Thanks,

    Alice

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply