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 |
|
mramey64
Starting Member
7 Posts |
 Posted - 2010-09-10 : 12:24:12
|
| I have a DTS package that copies records from a Progress Database(linked server) to my SQL 2000 database. I would like to modify the DTS to only copy records that have been updated since the last update date. This means I need to save the Update date and then use it on the next update. I would like to use time but the progress database has a time column but it's a text datatype? I'm using the SQL database as the backend of an Access app. I can't do any modifications to the Progress data. I have to just take what it gives me. Can anyone help me with the DTS?Thanks!MikeMichael |
|
|
|
|
|
DTS Variables