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 |
|
ArpitNarula
Starting Member
16 Posts |
 Posted - 2011-02-21 : 06:54:36
|
| Hi,Could someone guide me how can i create this scenerio in SSIS pkg.Source Database ASource Table CSource Table PDestination DataBase BDestination Table AC (source C)Destination Table CP (source P)1. Check if there is already any data in Table AC.2. If yes, do nothing.3. If no, copy the data from Table C.4. Check if there is already any data in Table CP.5. If yes, do nothing.6. If no, copy the data from Table P.Thansk in Advance. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-02-22 : 04:17:51
|
| experiment with the following and revert with your sample. (we're here to help, but you need to show evidence of helping yourself as well)select count(*) from table1insert into table3 (d,e,f)select a,b,c from table2 |
 |
|
|
|
|
|
Conditional Load