CODEWITHSUNDEEP
sql-servervisual-studiossisetlssis-2012
user10260750
user10260750

Reputation: 83

Executing SSIS package gives System.IO.IOException

I am trying to execute the package and every time I see the following error. Especially when I execute the data flow task.

Error :

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

Full Output:

------ 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 ==========

How can I fix it. My ispac file is in bin folder. I want to make sure the SsISDB catalog and Visual Studio are not fighting over this location

Upvotes: 6

Views: 8785

Answers (2)

Barry
Barry

Reputation: 31

Every time you start up an instance of SQL Server Manager, you have to go kill the SSIS Debug Host processes. However, I don't think they showed up until I tried to re-execute a package. I might try executing an empty, dummy package, fix the crash, then try again with the real package.

Upvotes: 0

Hadi
Hadi

Reputation: 37313

Based on the following article:

Possible Solution:

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.

enter image description here

Similar Issue links

Upvotes: 7

Related Questions