Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hepsi
Starting Member
1 Post |
 Posted - 2009-01-26 : 22:15:07
|
| Hi All,I have a table in remote database and the same type of table in my local database. What I have to do exactly is I have to load data from the remote database to my local database based on date i,e., input should be a date variable. If the values for that particular date is present in the remote database, it should insert in my local database. If the values for that particular date is already present in my local database, it should update my local database. How to acheive this SSIS? I'm new to SSIS. So, please help me in solving this.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-26 : 22:54:01
|
| Search for Lookup transformation task in here. There are lots of examples in this case. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 00:46:34
|
| see thishttp://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx |
|
|
|
|
|
|
Delete/Update Before Inserting