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 - 2003-02-12 : 07:15:04
|
| Pragash writes "I am using SQL Server 2000.I need to create a text file and upload the text file to an FTP server. I am using the Execute Process Task in DTS to do this. It all works fine when I execute this package in the DTS.But my problem is, when I schedule this package to run automatically, it just hangs. I checked the directory and path and everything else on the server, there is no problem. I even tried this with two different SQL servers, it gives the same problem. Is there a solution for this problem?" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-12 : 07:35:55
|
| I know there was a problem uploading single files with SQL2K with no service packs - it uploaded then deleted the file. Is your file uploading and staying ok ? Have you service packed it ?? if not SP1 fixes that problem.===========Paul |
 |
|
|
|
|
|
Automate FTP Upload using DTS in Agent - Job.