Hi All,

I know that it is possible to call a DTS package from another DTS package.

But does anyone know is it possible to Schedule a DTS package from another DTS package.

For example I will schedule Package1 to run every sunday at 10pm. Packake1 looks for a file. If the file is there then Package1 will call Package2 to load the file. Thats ok.

However, if the file is not there I want to schedule Package1 to execute again in 5mins to check for the file again. This will be a continous process till the file is found?

Alternatively can anyone suggest a better way of re-running a package until the file has arrived in the directory.

I have already posted a similar question about "Poll for a File"

Any help greatly appreciated

Thanks in advance