Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks, Generally we can use FILESIZE or FILETIME functions in the script to verify weather file exist on the specified folder. But these functions are not worked for Web files example share point sites.
ISNULL(FILETIME('http://myteamsusa/sites/Shared%20Documents/2013/WW38/GCRI_TDR_WW38.xlsx'))
How to check weather file exist or not on Share point web site folders ?
Thanks
Hi.
If you want to read from these files then you could use loads with error handling. Just check that the resulting table is not empty.
Thanks Whiteline. I tried this way also. But I am not sure I didn't get any values for ScriptError , ScriptErrorDetails & ScriptErrorCount in the TRACE statemement. I am using QV11.2 SR2. I need to turn on any seetings ?
I think you've missed something.
(see the attached image)