March 22, 2004 at 7:44 am
I'm trying to export data from SQL Server to a text file on an FTP server. My steps are selecting the SQL Server as Source, Text File as Destination, but when I browse to the FTP folder I get the error "You cannot save in the folder you specified. Please choose another location." What am I doing wrong? Does SQL Server not have the necessary permissions on the FTP server? Should I choose something else for the destination?
March 22, 2004 at 9:04 am
Check the permissions on the folder you are saving to; we do this all the time, and permissions need to be correct for the package owner ( If scheduled, the owner of the job).
Steve
March 23, 2004 at 9:36 am
also note that the ftp feature does not nativly support directory transversal as it seems it is a limited feature set for the ftp service.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply