Execute Process Task looses file

• Jan-155192

  SSCrazy

  Points: 2613

  More actions

  November 3, 2005 at 8:32 am

  #76451

  Hi all,

  I have a batch file that I want to run in a DTS - Execute Process Task.

  The tasks runs fine... for some time. Then it looses its pointer to the batch file. Then I need to open the task, and re-select the win32 process. After doing so, the task runs fine again. Even WITHOUT SAVING the DTS.

  This cannot be an issue concerning user-rights, because sometimes it works, without changing any rights.

  Has anybody experienced a similar problem? And found a solution?

  Many thanks,

  Jan

• Daniel Forrester-253836

  Say Hey Kid

  Points: 696

  More actions

  November 3, 2005 at 10:44 am

  #602192

  I've not come across this berfore. Try using a dynamic properties task to set the batch file location from a global variable each time the package runs.

  Daniel

• Jan-155192

  SSCrazy

  Points: 2613

  More actions

  November 4, 2005 at 6:37 am

  #602326

  Daniel,

  The batch file was calling some 3th party product batch files which call Java and they also changed the active directory a few times.

  I needed to simplified this, and indeed needed to use the dynamic properties task.

  So, your comment was helpfull, thanks.

  Jan