Re: DTS FTP & Scheduling

From: aaron kempf via SQLMonster.com (forum_at_SQLMonster.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 21:51:53 GMT

it's because when it's runnig as a scheduled job, it runs under that persons' permissions (that the SQL agent is running as)

check these 2 thigns:

1) make sure that user has perms
2) change to a UNC path instead of pushing to a F drive-- i assume you're talking about a mapped network drive (from your verbage)

or if you are really hard up, you could probably map the network drive programmatically using this:

exec xp_cmdshell 'net use f: \\happyserver\happyshare' 

-- 
Message posted via http://www.sqlmonster.com

Relevant Pages

  • RE: Automated Sorting Mail from DTS package
    ... The error is most likely due to whatever account that is running the DTS ... package (a scheduled job?) not having write permissions to the folder that ... > You do not have permission to create a message in this folder. ... I am pretty sure I have all the permissions set ...
    (microsoft.public.outlook.program_vba)
  • Re: error converting data type int to tiny int
    ... Do you mean use a T-SQL statement under Management, SQL agent, Jobs, or from ... Management Backup? ... > create a scheduled job yourself and forget about the Maintenance plan? ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Differential scheduled backups
    ... As with any scheduled job you can see the current or most recent status in ... Enterprise Manage under the Jobs node of SQL Agent. ... > databases/all tasks menu. ...
    (microsoft.public.sqlserver.setup)
  • Re: Export to Excel - File not created
    ... Does the network account that SQL Agent runs under have file create/delete ... Most good judgment comes from experience. ... however the Delete Excel file step and the Export to Excel step don't ... I thought maybe this was a permissions issue, ...
    (microsoft.public.sqlserver.dts)
  • Re: Workbooks.Open fails in scheduled job
    ... If it is failing as a scheduled job then the permissions aren't set the ... joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 ...
    (microsoft.public.excel.programming)
Quantcast