FTP a Flat File using SSIS

• CrazySam

  SSC Journeyman

  Points: 87

  More actions

  February 26, 2015 at 4:47 pm

  #304591

  I have a OLE DB Source with query and convert to Flat FIle. I want to FTP this Flat File.

  Can we FTP the flat file directly, without providing intermediate location like "D:\Working Directory" or any shared location for Flat File creation?

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  February 26, 2015 at 9:57 pm

  #1780465

  Hi, NO we cannot FTP a file directly.

  You need to create it on a UNC path first then you can send it to FTP.

  ____________________________________________________________

  AP