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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-07-05 : 01:40:31
|
| Hi Gurus,I have little bit idea to Create a DTS Package to copy any 5 tables from Pubs to Northwind. but how can i do the following ..?Create a log table to store the package start time, end time, execution duration, records affected. When any transaction inserts/updates/deletes any record in any of the 5 tables in Pubs the same has to be updated in Northwind. you can also use stored procedures inside the DTS Package.The DTS Package must run continuously. i.e. the package must identify the recently changed record in Pubs and should copy the same to Northwind. The DTS Package should run continuously.Please give your ideas.ThanksKK |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-07-05 : 02:25:01
|
| Are you trying to kill your databases?DTS aren't really designed to run continuously. If you want to run this sort of replication, you would be better of using triggers on the tables you're interested in. |
 |
|
|
spireite
Starting Member
12 Posts |
Posted - 2006-07-05 : 02:40:18
|
| Given you want to identify records changed and copy to another DB - Whats wrong with using transactional replication? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-07-05 : 02:53:30
|
| Sorry FriendsI am very new to DTSThis is my first assignment in my companythat's y i need ur suggessions-- kk |
|
|
|
|
|
|
DTS With LOG tables