Post reply

DTS help

  • January 22, 2009 at 11:36 am

    #94757

    I have a DTS which actully populates data from source to target on an incremental basis by checking previous days data. now in target table there is a unique index. In teh data transformation i have the property of "check constraints" turned on due to which if there are any duplicates coming from source the DTS fails. I need with few things here

    - Is it possible to produce a log of what all recs got duplicated.

    - If there are 10 recs to be moved from sourece to destination, can the DTs proceed further if the first rec is duplicated and it fails. only if 1 rec is duplicated will the rest 9 get processed, if so under what scenarioa. should i take it row by row transaction? any help on this wil lbe greatly appreciated.

  • February 2, 2009 at 5:43 pm

    #936828

    It can be done if you incorporate this logic in execute SQL task and check for duplicates at source before proceeding to next step(actual data import).

    MJ

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

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