daily data copy

Last Post 01 Aug 2008 09:35 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Aug 2008 09:35 AM
I have DTS schedule as a job on server AQW8 that take data from Oracle server and imports into DETQ12 server
It runs for 2 hours every night. Wont it make more since to run it right on destination server? the processing is dont on AQW8 which is third neither source nor destination server. Would not moving it to dest server improve DTS performance

Does data have to physycally go to from oracle through AQW8 and then to DETQ12


Acceptable Use Policy