BUG: DTS: Default Scheduling Information Displayed (221480)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q221480
BUG #: 54071 (SQLBUG_70)

SYMPTOMS

When viewing the scheduling information for a Data Transformation Services (DTS) package, in the Schedule Package option, a default schedule always displays, regardless of any scheduling changes that may have been made.

WORKAROUND

Note that this is merely a problem with the display. The package is still run at the scheduled time, even though each time you view the schedule it displays a default time. Any changes you make to the schedule are saved and the package is executed according to the changes made.

If you wish to see the current schedule information when editing a package, make your schedule changes by using the SQL Server Agent. To do this, perform the following steps:
  1. After creating and scheduling the package, move to the Jobs folder (located under SQL Server Agent in the Management folder), right-click the package, and click Properties on the shortcut menu.

    NOTE: You may need to Refresh the window for the package to appear).
  2. On the Schedules tab, click Edit.
  3. Make any necessary scheduling changes and click OK.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:11/3/2003
Keywords:kbBug kbpending KB221480
©2003 Microsoft Corporation. All rights reserved.