| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hello. I've read that the Apply within Data Propagator can perform additional SQL, or call a Stored Procedure, when processing a subscription set. However, all the information that I have read show examples of broad functions being performed, and I have not seen any that utilize values from the CD table. I'd like to perform some SQL, or call an SP, prior to a row being processed from the CD table but it needs to be specific to data on that row. I do not think something like this is available within the DProp functionality, as it seems to be only available to pre-set or post-set processing. The only way I think I can accomplish this is by utilizing triggers on the target. Does anyone know if SQL within the Apply can utilize values from the CD table? - Bill - |
![]() |
| Thread Tools | |
| Display Modes | |