Tim Riley


I am trying to delete a remote file as part of an SSIS package. The FTP Task I have to retrieve the file works fine. I use the same remote path variable and connection manager for both tasks. However, when the delete step executes I receive the error:

Error: 0xC002918E at FTP Task, FTP Task: Unable to delete remote files using "FTP Connection Manager 1".




Re: Error Deleteing Remote File

jwelch


Sounds like a permission issue.





Re: Error Deleteing Remote File

Tom Phillips

This is a known problem with the FTP task in SSIS trying to delete a file on a non-Windows FTP servers.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1074276&SiteID=1

I do not know if SP2 fixes this problem or not.





Re: Error Deleteing Remote File

Tim Riley

I can delete the files from the FTP command line. I have a DTS package that uses a .bat file to do this, I just want to put it into SSIS. Thanks for the info.



Re: Error Deleteing Remote File

Tim Riley

Is there a way to tell if the server is not Windows



Re: Error Deleteing Remote File

Rafael Salas

HAs this issue been aknowledge by Microsoft [Microsoft follow-up]




Re: Error Deleteing Remote File

Tim Riley

I don't understand your question. Your the closest thing to Microsoft that I have seen involved in any discussion in this area, anywhere I've looked.

Tim





Re: Error Deleteing Remote File

Tom Phillips

Yes, it is still an active bug report, reported over 1 year ago.

See: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126207




Re: Error Deleteing Remote File

Tom Phillips

No, you would have to know ahead of time what kind of server you are talking too.

However, there is a workaround on the thread I gave in the previous message. Basically, don't use the FTP task, use a script task and code it by hand.





Re: Error Deleteing Remote File

Cho Yeung - msft

We are aware of this bug and it will be fixed in the coming major release. Please contact CSS if you need a hotifx. Thanks