January 7, 2010 at 7:08 am
Error description....
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
01/07/2010 19:31:42,Archive files,Error,0,COSERVER,Archive files,(Job outcome),,The job failed. The Job was invoked by User Domain\UserName. The last step to run was step 1 (Archive backup files).,00:00:01,0,0,,,,0
01/07/2010 19:31:43,Archive files,Error,1,COSERVER,Archive files,Archive backup files,,Executed as user: CORP\SVC-IN-PXADMIN. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:31:43 PM Error: 2010-01-07 19:31:43.62 Code: 0x00000001 Source: Script Task Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.UnauthorizedAccessException: Access to the path '<Archive File Full Path>' is denied. at System.IO.__Error.WinIOError(Int32 errorCode<c/> String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName<c/> String destFileName<c/> Boolean overwrite) at ScriptTask_d6df0a174d734e478ac73c5ace862195.vbproj.ScriptMain.Main() --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target<c/> Object[] arguments<c/> SignatureStruct& sig<c/> MethodAttributes methodAttributes<c/> RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj<c/> BindingFlags invokeAttr<c/> Binder binder<c/> Object[] parameters<c/> CultureInfo culture<c/> Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj<c/> BindingFlags invokeAttr<c/> Binder binder<c/> Object[] parameters<c/> CultureInfo culture) at System.RuntimeType.InvokeMember(String name<c/> BindingFlags bindingFlags<c/> Binder binder<c/> Object target<c/> Object[] providedArgs<c/> ParameterModifier[] modifiers<c/> CultureInfo culture<c/> String[] namedParams) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript() End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:31:43 PM Finished: 7:31:43 PM Elapsed: 0.563 seconds. The package execution failed. The step failed.,00:00:00,0,0,,,,0
Hello everyone, I am facing the above error while executing the SSIS package from SQL job.
Using service user to execute the job.
Have all required permission to this service user to both Source and Destination Folder.
But still :w00t: getting the error....help me please.
Abhijit - http://abhijitmore.wordpress.com
January 7, 2010 at 7:13 am
What are the security settings for the SSIS package?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:21 am
No. There are no security setttings in the package.
Abhijit - http://abhijitmore.wordpress.com
January 7, 2010 at 7:35 am
Hello everyone, I am facing the above error while executing the SSIS package from SQL job.
Does the account the SQL Server Agent runs as have permission to those directories as well?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply