FTP Task in SSIS package

• forum member

  Ten Centuries

  Points: 1290

  More actions

  July 6, 2009 at 9:21 pm

  #155926

  Hi,

  FTP Task does work under development environment (in vs2005) but when i save it under sql server and schedule it to run daily it doesnt work(Unable to connect FTP)

  Package's protection level property set to EncryptSensitiveWithUserKey,and credentials for the FTP are in the task itself,i am not sure whether its work though

  OnError,Servername,NT AUTHORITY\SYSTEM,Database,{8C5658B9-E936-49BB-B965-807C612F53C2},{36D1843C-2BA5-4859-B10A-590B0FC95B02},-1073573489,0x,Unable to connect to FTP server

  Can somebody help me on how to resolve this

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 6, 2009 at 10:14 pm

  #1020866

  Double posted. Please post reponses here.