Results 1 to 3 of 3

Thread: FTP Deletion issue in SQL agent job

  1. 04-13-2006, 01:45 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    FTP Deletion issue in SQL agent job

    hello,
    I have a FTP task crated using SSIS that need to delete lot of files in a directory. This task is working fine if I'm Executing the SSIS package manualy but not working if I'm scheduling the SSIS package in SQL agent job.
    Anybody have faced this kind if situation is there any solution for this?.
    Reply With Quote Reply With Quote
  2. 04-13-2006, 02:37 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Does sql agent service account have permission to delete those files? Who is job owner?
    Reply With Quote Reply With Quote
  3. 04-13-2006, 03:00 PM #3
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231
    You are right rmiao, I forgot to check this permission issue for SQL agent service a/c.
    I appreicate your right direction.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules