Package Properties
Use this dialog box to set options for Data Transformation Services (DTS) applications.
Options
Turn on cache
Optimize the performance of DTS applications when using DTS Designer on computers running Microsoft® Windows® 2000. For this environment, the time needed to open a DTS package decreases significantly if you select this check box.
Refresh Cache
Cause the DTS application to recognize new scripting languages, custom transformations, OLE DB providers, and custom tasks that were added since the last time the cache was refreshed. This option is only available if the Turn on cache check box is selected. Registering a new task in DTS Designer will refresh the cache for tasks, but new OLE DB providers that were added will not appear in the DTS application until you refresh the cache.
Generally, click Refresh Cache after installing a new instance of Microsoft SQL Server™ 2000, registering a new DTS object, or adding a new OLE DB provider.
Show multi-phase pump in DTS Designer
Display the multiphase data pump options in transformation tasks in DTS Designer. You access the multiphase data pump options when configuring transformations in either the Transform Data Task or the Data Driven Query Task.
Turn on just-in-time debugging
Use the script debugger supplied with those products to debug your Microsoft ActiveX® scripts. This option is available only if you have Windows 2000, Microsoft Visual InterDev® 6.0 or the Microsoft Windows NT® 4.0 Option Pack installed.