Home Forums Reporting Services Reporting Services 2008/R2 Administration How to - RUN MORE than 1 SSIS package at the same time on the SQL Server, using DTExec.exe RE: How to - RUN MORE than 1 SSIS package at the same time on the SQL Server, using DTExec.exe

  • February 24, 2014 at 4:01 am

    #1691457

    ms-techie (2/23/2014)

    These Jobs are INDEPENDENT of each other.

    Are you sure about that?

    "The process cannot access the file because it is being used by another process " and then the job fails . This is because DTExec.exe Process is being accessed by many jobs

    Pls help

    I think it unlikely that this is the reason for the error. It's more likely that more than one of your packages are trying to access the same Source or Destination file.

    Also, you may get more reponse to your post if you submit it to the correct forum; you have posted in the SSRS forum.

    Regards

    Lempster