I not really sure where this problem is coming from. I have looked in numerous Microsoft articles and not really found anything applicable.
I have a SQL Server DTS package that *should* be run every day on Windows NT 4.0 machine. Whenever I schedule it, it doesn't though. (Other DTS packages work though)
In my DTS package it is running a Win 32 application to FTP to another machine to get the files to import, and then it starts importing them.
Now, it won't run as a schedule, and sometimes it won't run if I execute it directly from the DTS. But it will always run if I reset the destination of the win32 app (even though it is exactly the same) and then execute it directly from the DTS.
Does anyone know what the problem might be? I have reset the permissions so I doubt its that.
hope you can help!
I have a SQL Server DTS package that *should* be run every day on Windows NT 4.0 machine. Whenever I schedule it, it doesn't though. (Other DTS packages work though)
In my DTS package it is running a Win 32 application to FTP to another machine to get the files to import, and then it starts importing them.
Now, it won't run as a schedule, and sometimes it won't run if I execute it directly from the DTS. But it will always run if I reset the destination of the win32 app (even though it is exactly the same) and then execute it directly from the DTS.
Does anyone know what the problem might be? I have reset the permissions so I doubt its that.
hope you can help!