Monday, December 31, 2012 5:32 AM
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-
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
Monday, December 31, 2012 5:55 AM
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:
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
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.