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 |
|
tee11732
Starting Member
4 Posts |
 Posted - 2010-04-02 : 09:32:20
|
| Can someone please tell me the best way to implement the following:I need to grab a set of records from database A on server 1 and insert them into database B on server 2. I then need to update the records in database A if and only if they were successfully inserted into database B.This would run in an SSIS pkgs and Im estimating about 100 records per night. Also, if this isn't in the right location please point me in the right direction. Thanks in advance! |
|
|
|
|
|
Row by Row Processing in SSIS