DTS and D/b logging -
12-04-2006
, 04:16 PM
Hello,
Perhaps a little off topic for DTS but I was wondering what kind of target
database performance tuning I can do for a series of scheduled packages that
refresh data once every day? The process can be restarted should it fail so I
would like to minimize/avoid database logging if that's possible. Also, the
source of the data is a read-only DSS type database (DB2) so I don't need to
be concerned about uncommitted data etc. Any thoughts/advice/suggestions
would be appreciated!
TIA,
Chris. |