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 |
|
Jim77
Constraint Violating Yak Guru
440 Posts |
 Posted - 2006-08-17 : 19:13:14
|
| Hello board, I hope you don't get board with this so I will try and stick to bullet points.> I have scheduled snapshot replication in SQL2000 which is working.>the snapshot consists of 5 articles one of which needs to be horizontally filtered.>I tried to edit the dts package that the replication wizard generated by adding a subscriber task (Delete from a where prodid =5) and a on-success workflow line after the subscriber received the wanting to be filtered article.(which parsed fine in dts and qa)>it didnt do work>i am now having to resort to scheduling a job to remove the required rows on the subscribing server half an our after pushing on the distributing server takes place which is UGLYcould someone please point me in a better direction.Kind RegardsPain on Pain. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 19:21:45
|
| If you modified the DTS package, you then need to modify the job to point to the new SID of the DTS package or whatever it is called. Each package modification gets a new SID (I'm just going to use that name). So your job is probably referencing the older version. This is exactly why I choose to create the jobs myself rather than using the DTS scheduler wizard. The wizard uses these SIDS. I prefer this:dtsrun.exe -S ServerName -N packageName ...Tara Kizer |
 |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-08-17 : 19:30:47
|
| Sort of Tara thanks, but I have made transformation changes on that same DTS before, saved it, then ran replication and the desired effect was met it seems more specific to the filtering task within the dts. |
|
|
|
|
|
|
Dts Confusion in Push snapshot replication