I have created a SQLServer DTS script to retrieve and process a file located on an IIS FTP server.
The FTP step of the process seems to be working as expected, but it deletes the file once it has been fully downloaded. It does not generate an error, and if you watch the destination directory you see the file created, populated, and then deleted. I have another FTP that is working as expected.
This is obviously throwing a big 'ole monkey wrench into the rest of the processing. Has anyone seen this before? I am fairly new to the FTP Task, so I really hope it is a matter of me doing something stupid and not an inherent problem!