I have a package which won't run reliably and can't understand why. In production, a SQL job runs the DTS package, which uses a Dynamic Properties task to read an ini file and set such things as Connection object UDL pathnames, global variable values, and Execute Package task server names. This Dynamic Properties task fails fairly often.
This morning I watched an operator try to run the package using Enterprise Manager on his own pc, so in his own context. He just opened the package and tried to execute it task by task. The Dynamic Properties task is the first one in the flow, and it failed, saying that it could not open the ini file. The operator could open the ini file himself using Notepad, so clearly permissions should not be an issue.
Next the operator tried the same thing, but this time used Remote Desktop to get onto the server. The package ran without a hitch.
Other package we have that do exactly the same thing (SQL job, same owner, similar time of run, ini file in same folder, setting same sorts of things) are fine.
What should we investigate?
Thanks,
Bill