I do not have the cache turned on, but dts
is cacheing the information every time I run the
package ( The package runs faster almost every time).
How do I stop DTS from doing this? I need a clean
run each and every time I run one package or
any other package

DTS itself does not have any cache (apart from a specific option for
Lookups, but the cache duration is limited for the duration of that
execution only).

DTS is just some client side COM objects which are not persisted between
executions, so there is no data caching at all inside DTS.

You may be getting increased performance depending on your data source. SQL
Server will keep data in buffer for a period of time.

The following commands will clear your SQL server buffers and procedure
cache-

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE


--
Darren Green
http://www.sqldts.com

"Philip" <atec396 (AT) hotmail (DOT) com> wrote

Thanks, the two DBCC commands did help.