Post reply

How can i make the data transformation in DTS to do an update instead of insert?

  • August 14, 2012 at 2:04 am

    #260692

    Hi guys,

    this is the dilemma im in now. i have to create a DTS package that instead of doing the usual copy columns in data transformation, i need it to perform an update statement instead. Any ideas on how i should move forward with this??

    appreciate for any replies..TIA

    Cheers! 🙂
    [/url]

  • August 23, 2012 at 2:20 pm

    #1529453

    I forgot most of my DTS skills but since you have not received any responses I'll make a general suggestion:

    Instead of loading the data directly into your target table, load the data into a staging table using the current 'copy columns' method and then issue an UPDATE...JOIN to update your target table from the data in your staging table.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • September 10, 2012 at 6:29 am

    #1535644

    why arent you using SSIS? you can easily do it using SSIS.

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

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