SSIS: FTP task fails when called from execute package task

• Jim Mackenzie

  Hall of Fame

  Points: 3728

  More actions

  August 15, 2013 at 4:39 pm

  #277043

  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]