Page 1 of 2 12 LastLast
Results 1 to 15 of 21

Thread: FTP TASK in SSIS

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    FTP TASK in SSIS

    Hello,
    I'm uisng FTP task for sending file to different domain.
    I have spacial ID for access FTP and using the same FTP connection manager. It is working fine if i'm running this task manuly but not working as sql agent job. Do I need to have same ID for SQL agent service and FTP process. My sql agent service is running in different account.
    I appreciate you input for this issue.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, sql agent service account needs permission to access ftp. Or you can try setup that special ID as proxy account in sql2k5.

  3. #3
    Join Date
    Nov 2002
    Posts
    231
    rmiao,
    I did create proxy a/c and ran the job using this new credentail. I'm getting the following error.
    What I'm doing wrong now?

    Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 2). The step failed.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    How did you set proxy account?

  5. #5
    Join Date
    Nov 2002
    Posts
    231
    I created a Credential and then created Proxy A/c
    In Object Explorer, expand a server.

    Expand SQL Server Agent.

    Right-click Proxies and select New Proxy.

    On the General page of the New Proxy Account dialog, specify the proxy name, credential name, and description for the new proxy.
    After done this I have created job with run as this proxy A/C.
    I have tried to use windows and SQL log in but still getting the same error.
    What i'm doing wrong here?

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Did you use your special FTP id as proxy account?

  7. #7
    Join Date
    Nov 2002
    Posts
    231
    Yes, I did use that , it is not able to run the job at all now.

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Who is job owner? Can you post more details of your setting?

  9. #9
    Join Date
    Nov 2002
    Posts
    231
    Hi Rmiao,
    I appreciate your cooperation on this.
    I'm the job owner and I have all admin right to this server.
    here are some more info about my settings,
    Created a Credential with below value
    Credential Name=FTP_USER.
    identity =FTP_ID(which is given by client and I have created as SQL Login too)
    password=whatever password given by client
    Created Proxy Account
    Proxy Name=FTP_ID
    Credential Name-FTP_USER
    Active to the following subsystem: checked for SQL Server Integration Service Package
    Principals - Assigned all the Msdb roles(SQLAgentReaderRole,SQLAgentOpertorRole,SQLAg entUserRole)
    Created the job with Run as this proxy ID=FTP_ID
    But still I'm getting the below Error

    Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 5)

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Is FTP_ID a domain account? Did you let the proxy run cmdexec? How about the job? Run ftp command or SSIS task in the job?

  11. #11
    Join Date
    Nov 2002
    Posts
    231
    FTP_ID is SQL log in Account. I have chagned in my ID as I'm in the domain account. But event mine is not working.

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    What's your special ID for accessing FTP?
    Last edited by rmiao; 05-04-2006 at 03:19 PM.

  13. #13
    Join Date
    Nov 2002
    Posts
    231
    Yes , Rmiao,
    I can able to send the files using that spacail ID(FPT_ID) if I'm running the job manualy.

  14. #14
    Join Date
    Sep 2002
    Posts
    5,938
    Did you set that special windows account as proxy account? Who is job owner? Is job owner a member of sysadmin role?

  15. #15
    Join Date
    Nov 2002
    Posts
    231
    Rmiao,
    I think you lossing the track on my existting reply.
    Here is my configuration settings.


    I'm the job owner and I have all admin right to this server.
    here are some more info about my settings,
    Created a Credential with below value
    Credential Name=FTP_USER.
    identity =FTP_ID(which is given by client and I have created as SQL Login too)
    password=whatever password given by client
    Created Proxy Account
    Proxy Name=FTP_ID
    Credential Name-FTP_USER
    Active to the following subsystem: checked for SQL Server Integration Service Package
    Principals - Assigned all the Msdb roles(SQLAgentReaderRole,SQLAgentOpertorRole,SQLAg entUserRole)
    Created the job with Run as this proxy ID=FTP_ID
    But still I'm getting the below Error

    Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 5)

Posting Permissions

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