I have to execute a DTS Package after which pulls Data from the AS/400. But I cannot strat the package until the night job on the AS/400 finishes because the night job populates few files and the DTS has to pull those files.
How to you check whether the night job on the AS/400 has completed?
One way is to create a PC file at the end of the night job and make the DTS Pacakge to look for that file. If the file is found then execute the package.
Can you help me writing a VBScript to go and check for that particular file.
Note that the file can be stored only in a secured folder on the IFS partition on the AS/400, which means it requires a valid user id and password to built into the script to log on and check whether the file exists.
How to you check whether the night job on the AS/400 has completed?
One way is to create a PC file at the end of the night job and make the DTS Pacakge to look for that file. If the file is found then execute the package.
Can you help me writing a VBScript to go and check for that particular file.
Note that the file can be stored only in a secured folder on the IFS partition on the AS/400, which means it requires a valid user id and password to built into the script to log on and check whether the file exists.