How To implement the SCD with Row level log using CheckSum option in Tsql

Question

Post reply

How To implement the SCD with Row level log using CheckSum option in Tsql

nalini.kumari143

Valued Member

Points: 51
More actions
October 14, 2013 at 12:40 am

#299644

Hi Friends,
I want to implement the SCD with row level log using CheckSum option
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 optino in T-sql
Regards,
Nalini

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

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

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

TSQL is set-based, meaning, it's all or nothing in a transaction. If one row fails, the entire statement fails.

You can however achieve your requirements very easily in SSIS.

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

nalini.kumari143 Valued Member Points: 51 More actions · Answer 2

Hi,

Thank you for your reply , if suppose i am using with try and catch then what will happen...

nalini.kumari143 Valued Member Points: 51 More actions · Answer 3

Hi,

is it possible to do this task on control flow level in ssis

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 4

nalini.kumari143 (10/14/2013)
Hi,
is it possible to do this task on control flow level in ssis

No, you need a data flow.

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

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 5

Koen Verbeeck (10/14/2013)
nalini.kumari143 (10/14/2013)
Hi,
is it possible to do this task on control flow level in ssis
No, you need a data flow.

Any reason you don't want a data flow? They don't bite.

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

nalini.kumari143 Valued Member Points: 51 More actions · Answer 6

As per my Client requirement That's y am asking is it possible in control level using with execute sql

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 7

nalini.kumari143 (10/14/2013)
As per my Client requirement That's y am asking is it possible in control level using with execute sql

Clients and their strange requests sometimes. :rolleyes:

You can do it in TSQL with a cursor.

Enjoy the crappy performance 🙂

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