December 24, 2018 at 11:16 am
Hello All,
I have a series of ftp transactions that we have used for years in SQL 2012 and 2016 that use wildcards in the names to retrieve and push files to multiple FTP sites. To do this I am using psftp and a command task to execute a batch file. As I have said I have used this process many times. Now all of the sudden in a new package I can't get it to run outside of Visual Studio. In my development environment it works perfectly but when deployed it just hangs as a job. We have checked permissions and tried everything we could think of but it doesn't want to work. Is there something to look out for? I have found several script tasks that could work but I can't seem to get them to delete the remote file after transfer. Any advise would be helpful.
Thanks
Charles
January 4, 2019 at 7:04 am
There are several things to investigate. The remote site is one of the first things to look at. Do they perhaps have any new web security methods in place? Things that might limit the IP addresses that can access their site could be an easy fix, but would require work on the remote site. However, as you have multiple such steps, you may have multiple sites, and that suggests that the problem might well be on the server. Does it have permission to run the psftp program, or file share access to the executable? Does that program then require read/write access to the folder it's located in? Permissions could also be a quick fix. Just remember that executing on a server is an entirely different security context than when running local to your machine. Even the operating system is different. Is that program compatible with running on the server OS? Also, does the server have the same network security as your local machine? Probably not. Might need to open a port in a router somewhere to allow this traffic to get "out the door", so to speak. Talk to your network folks and ask if there have been any recent changes to network security. That's probably the top several ideas, but it's not exhaustive. Hope it helps.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply