• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Checking 2 columns in 2 tables row by row using ssis

hi,
i have 2 tables   A and B. i attached a file below.
i have a task to check each value of column A with each value of column B.
iF if value 30 exist in A and Not present in B.
we should get  a result set "30 deleted from A". and if New values found in B it should be entered into other resultset.
I am trying to work it out through SQL server 2005 or SSIS
i am not able to find a way.
please help
New-Text-Document.txt
0
kgadde
Asked:
kgadde
1 Solution
 
howyueCommented:
ur question sounds to me like a synchronization between 2 tables. there are many ways of doing this, based on ur situation, for example using TableDiff provided by sql 2005, using 3rd party program, using storedprocedure or query. i did once before using storedprocedure synchronizing 2 database in different region using linked server, which suited my circumstance.

to give u a rough idea how to do it in query, check out my sample code.
/* Get whatever value exist in table A but not table B */
INSERT INTO B
SELECT A.Value 
FROM A
LEFT JOIN B 
	ON A.Value = B.Value /* u need to specify all the columns to compare here */
WHERE B.Value IS NULL
/* Get whatever value exist in table B but not table A */
INSERT INTO A
SELECT B.Value 
FROM B
LEFT JOIN A
	ON A.Value = B.Value /* u need to specify all the columns to compare here */
WHERE A.Value IS NULL

Open in new window

0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now