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 |
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-05-24 : 11:53:47
|
Hi everyone,I have an Execute Process Task that run a batch file on server1. It works when I run it from my local desktop. But when I remote into server1 and I'm able to connect to the FTP server but it gets stuck when is trying to transfer the file. Any idea what is going on? how can I get around this? |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-05-24 : 15:24:44
|
How are you running your package on the remote server? Did you copy your package to that server or install it into MSDB? Under what security context is the pacakge executing?How does FTP come into play? Can you give us more details? Perhaps a step by step? |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-05-24 : 16:45:27
|
How are you running your package on the remote server?I run it using BIDS (manually)Did you copy your package to that server or install it into MSDB? No, I UNC (\\servername\directory\*.sln). I open and run the *.sln file manually.Under what security context is the pacakge executing?A developer'sHow does FTP come into play? Can you give us more details? Perhaps a step by step?The ftp transfers ten .TXT files to the FTPserver.put \\....1.txt C:\\folder\\1.txt |
|
|
zstarsales04
Starting Member
20 Posts |
Posted - 2010-05-25 : 02:28:57
|
spam removed |
|
|
|
|
|