Welcome to WebmasterWorld Guest from 54.167.102.69

Forum Moderators: phranque

Message Too Old, No Replies

SQL DTS Question

     
8:51 pm on Jul 13, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 12, 2003
posts:74
votes: 0


I would like to schedule a SQL 2000 DTS Package through the XP Scheduler. Does anyone know if I can do that?

Any help would be greatly appreciated!

Shuvi

9:29 pm on July 14, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 17, 2002
posts:124
votes: 0


actually, you need to schedule it thru enterprise manager to schedule it as a scheduled job.

XP Scheduler only schedules tasks for your computer. Which can not be dts tasks.

Do you need help setting up a scheduled dts task?

12:36 pm on July 15, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 12, 2003
posts:74
votes: 0


Yes because I did set it up through the Enterprise Manager Scheduler and it gave me a error message when it tried to run. Something with my Windows NT password was not found. I don't understand that because I am able to run it manually in the enterprise manager. Is there some kind of a setting that I'm missing? I'd really appreciate help with this.

Thanks!

8:38 pm on July 15, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 17, 2002
posts:124
votes: 0


It's all based on the authentication model you use.

Either windows authentication or sql login mode.

You can look at the permissions of the dts task, to make sure the username that is used to run the dts has permissions.

12:40 pm on July 16, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 12, 2003
posts:74
votes: 0


Where do I look for permissions?