Problem with Ftp Task Limitation for moving files
Hi there,
I suffer a problem for reading files from ftp into local computer by SSIS FTP Task. It is because flat files are being sent during executing SSIS package, the delete operation in FTP task can not judge the files are processed or not in ftp server.
Ideally, is that any functions like MOVE FILES from ftp to local in SSIS?
Thanks & Regards,
db
November 11th, 2010 10:01pm
you can do it with Two Separate FTP Tasks
in first one just COPY files from remote FTP to local
in second one delete files from remote FTP folder
this will guarantee that first copy will perform and then Delete.
http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 2:17am