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".
Sounds like a permission issue.|||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.
|||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.|||Is there a way to tell if the server is not Windows?|||HAs this issue been aknowledge by Microsoft? [Microsoft follow-up]|||
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
|||Yes, it is still an active bug report, reported over 1 year ago.See: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126207
|||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.
|||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
No comments:
Post a Comment