Post reply

How To implement the SCD with Row level log using CheckSum option in Execute Sql Task

  • October 14, 2013 at 12:47 am

    #281341

    Hi Friends,

    I want to implement the SCD with row level log using CheckSum option in Execute Sql Task

    My Source table : Emp_Source(EId ,EName,Sal,Deg,Staus) -- here staus is add/update/delete

    My Destination Table : Emp(Eid (primarykey) ,E name,Sal,Deg,Flag,Start date,End date,Check_Sum_Value) here flag : y/N

    My Log Table : Log(EID,Erronumber,ErrorDes)

    Now my aim is in source level any error is coming then go to that row in log table other wise record go to destination table with check sum option i.e SCD.

    Will you please any one guide me how to i have implement this SCD with row-level log using check sum option in Execute Sql Task.

    Note: i do not want to implement the scd with row level log in dataflow level, i want to implement in control flow level only.

    Regards,

    Nalini

  • October 14, 2013 at 2:30 am

    #1658196

    nalini.kumari143 (10/14/2013)

    Hi Friends,

    I want to implement the SCD with row level log using CheckSum option in Execute Sql Task

    My Source table : Emp_Source(EId ,EName,Sal,Deg,Staus) -- here staus is add/update/delete

    My Destination Table : Emp(Eid (primarykey) ,E name,Sal,Deg,Flag,Start date,End date,Check_Sum_Value) here flag : y/N

    My Log Table : Log(EID,Erronumber,ErrorDes)

    Now my aim is in source level any error is coming then go to that row in log table other wise record go to destination table with check sum option i.e SCD.

    Will you please any one guide me how to i have implement this SCD with row-level log using check sum option in Execute Sql Task.

    Note: i do not want to implement the scd with row level log in dataflow level, i want to implement in control flow level only.

    Regards,

    Nalini

    This is the same question as in this thread (with answers):

    http://www.sqlservercentral.com/Forums/Topic1504324-392-1.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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