Strange issue this was working fine before any issues

  • Smash125

    Hall of Fame

    Points: 3527

    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

  • Smash125

    Hall of Fame

    Points: 3527

    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()

  • hvermaak

    SSChasing Mays

    Points: 642

    Just wondering have you checked the package isn't already running?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply