Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Sql Server 7 DTS package scheduling NOT SAVING

Author  Topic 

vosspm
Starting Member

1 Post

Posted - 2004-11-17 : 11:20:56
Working in Sql Server 7 with a DTS package that simply imports a fixed-width text file into a table.
This is under DTS - Local Packages
When changing the schedule at "Schedule Package...", exiting via the OK button, then returning to "Schedule Package...", the settings are back to the default of current date, 12:00AM, once-per-day.

Is there an underlying file on the server that controls this info or particular setting I should look for to resolve this??
Many thanks..

Pete Voss - ICA I/T

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2004-11-17 : 14:26:53
Sounds like access rights - can't remember of the top of my head what access you need to schedule a job but will look it up at work tomorrow unless someone else can help before then



steve

To alcohol ! The cause of - and solution to - all of life's problems
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2004-11-18 : 03:23:16
Are you a member of sysadmin?

steve


To alcohol ! The cause of - and solution to - all of life's problems
Go to Top of Page
   

- Advertisement -