Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

get existing record from source to destination

Status
Not open for further replies.
dbsql

dbsql

IS-IT--Management
Mar 29, 2007
19
US
Hello,

new to ssis so wanted to find out


how to compare the data in the destination then get data from source and insert into destination what exist


for example


i have set of record id in the destination.


based on that i need to bring that record id only from source to destination.


Thanks


Pat



 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
373
Cpreston
Cpreston
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
876
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
291
fredericofonseca
fredericofonseca
BTrees
  • Locked
  • Question
Load Multiple Files from Source to Respective Multiple Folders (SSIS) 1
Replies
4
Views
192
BTrees
BTrees
kfschaefer0727
  • Locked
  • Question
New to SSIS - Create pkg to validate data, does it exists in a table
Replies
0
Views
222
kfschaefer0727
kfschaefer0727

Part and Inventory Search

Sponsor

Back
Top