June 5, 2013 at 3:02 am
The process cannot access the file 'a:\test\extracted\Data1_OPTS.Data1_OPTS.287.2_4_2.20130301.034710.dat' because it is being used by another process
We have two packages with names Data1_OPTS.dtsx and Data1.dtsx.
Both process .dat files
Files names for both packages are
'D:\dats\Data1.Data1.287.2_4_2.20130301.034710.dat'
'D:\dats\Data1.Data1.287.2_4_2.20130301.034710.dat'
These two packages are child packages and parent package calls child package and these files what i have mentioned are in a folder. What i can make out is there a conflict of names because of this i am getting this issue. I have other child packages when you run those with any of these package.This goes fine. We have written script task it will unzip dat files in a folder and pick these files for processing
June 5, 2013 at 3:05 am
0
Hi guys Below error message i am getting Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> java.io.FileNotFoundException: The process cannot access the file 'D:\dats\Data1_OPTS.Data1_OPTS.287.2_4_2.20130301.034710.dat' because it is being used by another process. --- 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()
June 5, 2013 at 3:25 am
Just wondering have you checked the package isn't already running?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply