Hi,
I have a VB script within an SSIS package which is simply reading files using the following code to check if they exist:
My.Computer.FileSystem.FileExists
Most of the time it works fine but sometimes there are intermittent issues where this check returns false even though the file exists. When the check is rerun 1 min later it works fine again.
SAs have checked the server and network connections and there doesn't seem to be any issue with the network connections.
Just wondering if anyone else has experienced anything similar with this check? I don't see any reason why it's failing at the moment. Code is running on a 64 bit Windows 2003 machine.
Many Thanks
I have a VB script within an SSIS package which is simply reading files using the following code to check if they exist:
My.Computer.FileSystem.FileExists
Most of the time it works fine but sometimes there are intermittent issues where this check returns false even though the file exists. When the check is rerun 1 min later it works fine again.
SAs have checked the server and network connections and there doesn't seem to be any issue with the network connections.
Just wondering if anyone else has experienced anything similar with this check? I don't see any reason why it's failing at the moment. Code is running on a 64 bit Windows 2003 machine.
Many Thanks
