Question Regarding the Time out in SSIS but it is not database connection
All, I have a step in SSIS that copy data from one location to our network location which doesn't need any third party tools. i'm using execute process task in ssis using command lines for copying, deleting, moving operations. Since it is a flat file when the file is opened on the source location, i.e file is not closed my ssis package is **copying** the files . /* But where as deletion operation in source folder was not sucessfull since the files are open. i repeat copying is done successful when the files are open but deletion is not done */ So with this on whole night it is running at same step and not even failing. Since it is a execute process task i'm not able to set time out option available on data base connections. So how can i handle this kind of situations please suggest and if possible please provide me the code to set time out for execute process task. FYI : i would like to handle this situation by setting time out for execute process task if it is taking more then as usual time then i would like to make it stop the job and sent a failure email.
You may consider raising and event for the task. This give one the possibility to report errors, warnings,and send progress information about the task to the package. The object in the Script Tasks has a property called "Events" that contains methods that allow one to do this type of tasks.