April 27, 2016 at 8:23 am
Hi to all. Many many months ago I developed an SSIS package with FTP task. This all worked. I created Integration Services Catlog, set things up and scheduled a job to execute the package. This all tested and worked fine. I then disabled the sql jobs until given the green light which was today. I expected things to work however package execution now fails.
An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.
The package imported into Integration services has not changed.
I am a bit miffed. Anyone have any ideas?
Phil.
UPDATE: I think my memory fails me. I am using WinSCP to perform the FTP task. I guess the SQL job has never worked!
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply