Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Copying a file to a shared network folder using SQL Server Agent

Respondido Copying a file to a shared network folder using SQL Server Agent

  • Friday, February 15, 2013 11:42 PM
     
     
    Sign In to Vote
    0

    Hello. I am fairly new to SSIS, so forgive me if my question is weak.

    I have a SSIS package that copies an Excel file to a shared network folder. The package is run using a proxy account from the SQL Server Agent. However, the process gets an error when it gets to the step that copies the Excel file. I am pretty sure it is an authentication problem, but I am not sure how to give the proxy account authentication to the folder on the shared network drive. Any ideas would be appreciated. Thank you very much.

    -Ecoinc

     

All Replies

  • Saturday, February 16, 2013 12:37 AM
     
     
    Sign In to Vote
    0
    Are you using a mapped drive (F: for the network drive \\networkcomputer\folder) or UNC (\\networkcomputer\folder)?  I have only been able to get the UNC to work.

    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com

     
  • Saturday, February 16, 2013 4:12 PM
     
     Answered
    Sign In to Vote
    0

    Silly question, but have you reviewed the ACL to confirm the account has write access to the folder?  Can you confirm the share is available to browse to when opened on the server?

    If you can, attempt to run the SSIS package through the execute package utility while you are logged into the sever using your own account (assuming it has access to the destination folder).  

     
  • Saturday, February 16, 2013 6:41 PM
     
     Answered
    Sign In to Vote
    0
    Your proxy account should have access to that folder. Go check the folder security for this account with read and write access.

    Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com

     
  • Sunday, February 17, 2013 2:25 AM
     
     
    Sign In to Vote
    0

    Hi,

    Go to the target machine and properties of the folder. Basically you need to grant Change (share permissions) AND Modify (NTFS permissions) on the target folder to the proxy account.

    Thong