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-05-03 : 09:31:17
|
Karson Alford writes "SQL Server 2000, Windows 2000 sp 1
I have an ActiveX Scripting Task with the following code.
Dim objFTP
Set objFTP = CreateObject("AspInet.FTP")
Set objFTP = Nothing
Main = DTSTaskExecResult_Success
If I run this manually everything works great.
If I run this from a scheduled job (ie using dtsrun from the command line) it hangs as soon as it gets to the CreateObject.
Note: This hangs forever there is no timeout.
This is happening on one of our machines. If I move the dts package to another machine and schedule it the schedule runs fine.
We have been looking for a solution everywhere I will list several things we have tried.
1) Gave Everyone full control of .dll.
2) Resaved and recreated package on machine.
3) Changed who SQLServer was running under using SQLServerAgent.
4) Running dtsrun from the command line.
5) Reinstalled .dll.
HELP!!" |
|
|
|
|
|
Scheduled DTS packages hanging forever.