Error 2 System.UnauthorizedAccessException: Access to the path '*:\*******\******\******.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)
Recently, when one of my team mate created a package in the system dedicated to him and later, deployed it into Server. When we tried to run the package from Server, we got this error. All these days, we never had a problem but suddenly we had this issue as Server was recently updated. "Error 2 System.UnauthorizedAccessException: Access to the path '*:\*******\******\****** .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 " I did a quick research and found out error is due to security limit given to User accessing the server. Solution: Right Click on the Package and Go to Properties. In Properties, Go to Security Tab and Check if the user is given Full Permission....