Hi All,
So we've got a standard FTP package that pulls a file from an FTP server and deposits it nicely in the folder of your choosing, pretty standard stuff. When I execute the package in SSDT it runs through no problems and grabs my file like a good little package.
However! When I call this FTP package using an Execute Package Task from within another SSIS task the execute package task fails giving the wonderfully useful error message: FTP Package Failed. Eventvwr is similarly useless and I've even had a look at procmon with no pointers in the right direction.
I'm using the standard FTP transfer and not SFTP. Has anyone come across similar issues?
Cheers,
Jim.
SQL SERVER Central Forum Etiquette[/url]