not knowing much more about your scenario I would simply suggest if its an ftp location then use a DTS package.  its FTP object is very easy to work with for retrieving files.  if there's a server share instead then the T-SQL script may be slightly easier.  if the flat file is just rows of records then running a bulk insert statement from either a DTS package or a T-SQL script should be a piece of cake.