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 |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2010-01-22 : 08:28:16
|
| I need to regularly transfer records from one database to another, and cannot use replication. So I am using an SSIS package to transfer the data. My question is this: Once the data transfer has started (it takes about 30 seconds to run), if new records then come in to the table during the run, are they picked up in the transfer or are they not queued until the next run?I am selecting based on a timestamp:select * from table where timestamp > last time I started the packageThanksStonebreakerThe greatest obstacle to discovery is not ignorance - it is the illusion of knowledge. -Daniel Boorstin |
|
|
|
|
|
when data transf starts and new data comes in...