sql-server - 执行 SSIS 包给出 System.IO.IOException

Question

我正在尝试执行包，每次看到以下错误时。特别是当我执行数据流任务时。

错误 :

System.IO.IOException: The process cannot access the file 'C:\PPE_OVERRIDES.ispac' because it is being used by another process.

完整输出:

------ Build started: Project: PPE_OVERRIDES, Configuration: Development ------
    Build started: SQL Server Integration Services project: Incremental ...
    Starting project consistency check ...
    Project consistency check completed. The project is consistent.
    Error : System.IO.IOException: The process cannot access the file 
        'C:\PPE_OVERRIDES.ispac' because it is being used by another process.
       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.File.InternalDelete(String path, Boolean checkHost)
       at System.IO.File.Delete(String path)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow)
    Build complete -- 1 errors, 0 warnings
    ========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

我该如何解决。我的 ispac 文件在 bin 文件夹中。我想确保 SsISDB 目录和 Visual Studio 不会争夺这个位置

Answer 1

基于以下文章:

Fix SSIS Error while execution: System.IO.IOException: The process cannot access the file ‘PATH\Project.ispac’ because it is being used by another process.

可能的解决方案:

Need to kill the Windows processes (SSIS Debug Host, and SSIS Debug Host (32 bit)) related to SSIS Debug and restart Visaul Studio to address the problem.

类似问题链接

The process cannot access the file 'ssisproject.ispac' because it is being used by another process.

SSIS: The process cannot access the file ‘*.ispac’ because it is being used by another process

SIS: The process cannot access the file ‘*.ispac’ because it is being used by another process