Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-16 : 14:31:14
|
| Alexander writes "I am using SQL Server 7. I have created a dts with 9 steps to automate a process. In this dts I am calling other dts using dtsrun, I am also calling a few .bat files, along with iexplore.exe to hit a web site, and also callig CuteFTP Pro to downlaod files from a Secure FTP site.When I run this package from dts it works perfect. However, when I schedule it, it fails. I have isolate the problem to be the task calling CuteFTP Pro. The CuteFTP Pro is called using using a script. The job returns fail after a very long time.I am working directly on the server and have check all of my paths to ensure that they are correct. I can see that CuteFTP started by using Windows NT Task Manager. But nothin else happens.Any ideas?Thanks." |
|
|
|
|
|
dts and Job schedule