This is getting seriously annoying. I tried switching out to a Script Task and again, this works in BIDS without an issue, but the SQL job seems to hate me today.
It has to be a permission I missed somewhere, but I'm unsure of what since I can write to the directory using that login.
Error: 2014-11-21 10:53:54.91
Code: 0x00000001
Source: Copy Detail Report to eFolder
Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.UnauthorizedAccessException: Access to the path '\\NASshare\TeamFolder\Folder\Details_201411210952.zip' is denied.
at Microsoft.VisualBasic.FileSystem.FileCopy(String Source, String Destination)
at ST_ece75f85271046c584a94575b1eeaab9.vbproj.ScriptMain.Main()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()
End Error
I am using the FileCopy method of Visual Basic 2008.