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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 FTP SSIS

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?
Go to Top of Page

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's


How 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
Go to Top of Page

zstarsales04
Starting Member

20 Posts

Posted - 2010-05-25 : 02:28:57
spam removed
Go to Top of Page
   

- Advertisement -