homepage Welcome to WebmasterWorld Guest from 54.211.230.186
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
SQL DTS Question
Shuvi

10+ Year Member



 
Msg#: 6048 posted 8:51 pm on Jul 13, 2004 (gmt 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

 

crosenblum

10+ Year Member



 
Msg#: 6048 posted 9:29 pm on Jul 14, 2004 (gmt 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?

Shuvi

10+ Year Member



 
Msg#: 6048 posted 12:36 pm on Jul 15, 2004 (gmt 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!

crosenblum

10+ Year Member



 
Msg#: 6048 posted 8:38 pm on Jul 15, 2004 (gmt 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.

Shuvi

10+ Year Member



 
Msg#: 6048 posted 12:40 pm on Jul 16, 2004 (gmt 0)

Where do I look for permissions?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved