BUG: DTS: Default Scheduling Information Displayed

• Microsoft SQL Server version 7.0

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 this to be a problem in SQL Server version 7.0.

Additional query words: ent man entman SEM Data Transformation Services MMC Import Export

Keywords          : SSrvAdmin kbbug7.00 kbSQLServ700bug 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 1, 1999