Hi, i've a package that uses FTP to send files. The package runs fine from BIDS but fails from agent with"Unable to connect to http://FTP..." error. I am usin a config file. FTP ID and PWD was provided by the client.
When you run the package from SSMS, it is run directly from your computer, but with SQLAgent it is run from the DB server. Check if there's dome firewall rule that prevents the server from connecting to an external ftp site.
Hope this helps
Gianluca
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply