Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Access to the path '.dtsx' is denied ?

回答済み Access to the path '.dtsx' is denied ?

  • Monday, December 31, 2012 5:32 AM
     
     
    Sign In to Vote
    0

    Hi ,

    I have created SSIS package earlier and it was working greate as per our requirement. After very long period i have open it foe modification and try to build. It was not build and give me error message. Below are the error message-

    Error Detail-->

    "Error 2 
    System.UnauthorizedAccessException:
    Access to the path 'N:\SSIS\GC_Sales_Commission_Report\GC_Sales_Commission_Report\
    bin\GC_Sales_Commission_Report.dtsx' is denied.    
    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
    at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes)
    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow)  0 0 "

    To overcome this i donot have any good appraoched, please suggest me any goos approach.Thanks

     

All Replies

  • Monday, December 31, 2012 5:55 AM
     
     Answered
    Sign In to Vote
    0

    Check the access to that folder, you need full access to do certain operations. Create a proxy account with full access and use that to do the same. Admin would have take out the permissions for the account with which you are trying to execute the packages:

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/65f10232-1767-4fc0-aa4a-fc1ec38bbe35/

    Regards,Eshwar.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked As Answer by Maggy111 Monday, December 31, 2012 6:23 AM
    •  
     
  • Monday, December 31, 2012 6:23 AM
     
     
    Sign In to Vote
    0

    Thanks Man.

    But i create my own logic for it.

    I did right click to SSIS package folder and go to properties-> Security tab-->and give full control to Users group and after build and run.

    Thanks for provide your one of the crusious time for my task.