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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2004-02-19 : 01:32:26
|
| Hi ,We have an .exe file which triggers a DTS to actually export the data out from a large table . The DTS takes usually few hours to complete the job. Now there is separate requirement to trigger a new DTS that will import data into the same table . The schedule for this import is expected to run sometime between when the previous data export is in progress . Would like to know whether the above activity i.e parallel data/ import and export is possible on a single table . The data will be a appended rather than truncate before the import and export process . Will the table be locked by the first export process so that the import process will fail or both can run in parallel with conflicting schedule . Thanks and Best Regards |
|
|
|
|
|
Parallel data import /Export on a single table.