Sometimes you can be in the situation where we filled up the disk space due to so Integration Services. This problem may be due to some misconfiguration in installation or the high number of active jobs. we can have different solution: Continua a leggere
Sometimes when a SSIS package on visual studio on debug mode crash after that we have this error:
ispac file in use by other proces
System.IO.IOException: The process cannot access the file ‘c:\folder\ssisproject.ispac’ because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.Delete(String path)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow)
To resolve this problem you have to :
- Open task manager
- Finf operation with these names:
- SSIS DEbug Host
- SSIS DEbug
- Kill them
This happens when SSDT/Visual Studio crashes during runtime. If you kill SSDT then the SSIS Debug Host will still be active locking the ISPAC file.