Post reply

Update SQl Server database with validations thru Text Source files

  • April 5, 2005 at 8:26 am

    #61118

    I was to create a Package which should UPDATE (not insert) my SQL Server table. In between I also want a validation layer to check for proper data being fetched

    Please tell me how can I do this

    Thanks 

  • April 5, 2005 at 11:51 am

    #550612

    Insert the data into a worktable, then run your validations and follow that with your updates. Finally drop or truncate the work table.


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

  • April 5, 2005 at 10:08 pm

    #550676

    I thanks for ur answer

    I would appreciate if I could get it in more detail

  • April 6, 2005 at 6:30 am

    #550755

    Create a table that has the same schema as the main table, let's call it TABLEA_WORK.

    Using DTS put the data into that table.

     

    If there are no problems, use the primary key to update TABLEA.

    So we have TABLEA with 2 column, an IDCol, DataCol

    Update TABLEA set DataCol = TABLEA_WORK.DataCol where TABLEA.IDCol = TABLEA_WORK.IDCol


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

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

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