Post reply

SQL Update Query

  • January 19, 2008 at 1:17 pm

    #178374

    I need to update a table that resides on one server with data from a table that resides in a database on another server. I tried using a OLEDB Data Source connected to OLEDB Data Destination but that append all the records. How can I slip the update in so it updates the records on the Destination and not append them. I have a common ID column in both tables.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

  • January 20, 2008 at 8:08 pm

    #770027

    Could you provide your scripts?

  • January 20, 2008 at 8:32 pm

    #770028

    see linked servers in BOL. then use 4 part naming convention

    update MyTable

    set field1 = b.field1

    FROM myTable a

    JOIN serverName.databaseName.ownerName.MyTable b

    On a.id = b.id

  • January 21, 2008 at 8:10 am

    #770158

    This is being done within a Data Flow task, so I am not sure what you are asking.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

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

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