Hi Yudee, can you send us the error message? Are you getting it in a log? If so, which log?
Thanks,
Samuel Lester (MSFT)
Hi Yudee, can you send us the error message? Are you getting it in a log? If so, which log?
Thanks,
Samuel Lester (MSFT)
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
Error messages:
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\Servername_ADVENTUREWORKS_ADVWORKSPRODUCTTRANS\20070625161637\' is denied.
Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
I totally followed by tutorials of replication, repldata is new created folder
sharing for windowns accounts like shown below
repl_distribution read
repl_merge read
repl_snapshot Full control
the settting for these accounts same with security setting
any idea about this error?
many thanks
Can you confirm that xp_cmdshell is enabled? Also can you confirm that the account your snapshot agent is running under (either the windows impersonation account, of the SQL Server agent account on your publisher) has write, and list files and folders rights on the publisher?Error accessing report,sql error