Hi,

We have recently upgraded from 6.17 to 7.07 and are now getting the following errors whilst executing SSIS package tasks (that seem to run at the same time as other tasks):

Exception in Task: Unhandled exception: System.IO.IOException: The process cannot access the file 'C:\Program Files\VisualCron\MSSQL2008\ssis_debug.txt' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
at System.IO.StreamWriter.CreateFile(String path, Boolean append)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding)
at System.IO.File.InternalAppendAllText(String path, String contents, Encoding encoding)
at System.IO.File.AppendAllText(String path, String contents)
at X4BNvMUs4WcOcyomFM.zdAVboDFjkUkqUeHPE.rTVq7bdWq(String , Boolean , Boolean )
at SSISExecute2008.SSIS2008.nRdOfaRArHsHGSpwl8(Object , Boolean , Boolean )
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task)

What we would like to know is can we set these text files that are used for a job so this issue of the file locking whilst being used is not affected by other jobs that seem to be using the same file?

Let us know as this is causing false errors.

Thanks

Mike

I am not sure but we will remove the debug writing for version 7.0.8. Please download that. Hopefully it will be released today.

---

Hi,

Thanks, have installed the update. Will see how it goes.

Mike