 | |
Inremental Update in DTS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Inremental Update in DTS -
11-23-2004
, 07:51 AM
#2
| |||
| |||
|
|
Hi All, Can any tell me how can i plan only get the rows that have been updated only after the last DTS Process. Thanks, Mansoor |
#3
| |||
| |||
|
|
Query by a relevent field that has been stored on completion of the last process. Have a look at the thread from yesterday "Incremental export best practice?" by Johnny Orson. "Muhammad Mansoor" <mansoor (AT) hadeedian (DOT) net> wrote in message news:e3pgJLW0EHA.2572 (AT) tk2msftngp13 (DOT) phx.gbl... Hi All, Can any tell me how can i plan only get the rows that have been updated only after the last DTS Process. Thanks, Mansoor |
#4
| |||
| |||
|
|
Well, the answer that you had referred seem to be a good solution, but what should i do if there is some update in some already exported entered tables ? |
If you have monotic key then query the maximum value and seed the
state/store table with that value, or similar for a date.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.