Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS FTP to Linux server - CHMOD

Author  Topic 

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2013-08-14 : 14:55:09
I've set up an SSIS package to ftp a text file (created from a data extract) to a Linux server. This works fine. I used the ftp task in SSIS and create a new file/filename each time it runs (variable for the filename).

There is an issue with the permissions on the Linux side though. Now let me say that I have no experience with Linux. The person setting up the import on the Linux side tells me the file needs to be CHMOD 666 to set permissions. He wants me to do it when I ftp the file over to linux. I've searched quite a bit and can't find much on how to do this. Can it be done from within SSIS?

He's tried some things with permissions on the directory on the Linux side (CHMOD 775 or 777 or 755) and it still doesn't work. So it's back on me to figure out how to CHMOD 666 it with my SSIS package.

If anyone can help, it is much appreciated.

Thanks in advance

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2013-08-15 : 11:20:49
The Linux guy informed me that the issue is fixed. I thought I'd post the fix just in case it might help someone.

One thing I did which may be unrelated was change the IsAsciiTransfer property to TRUE.

Here's what the Linux guy sent me:
"
We changed the umask setting for Linux vsftp dameon. Umask was at 022, basically removing the write bit for users and groups, we set it at 000

See http://www.cyberciti.biz/tips/understanding-linux-unix-umask-value-usage.html for umask

What is VSFTP https://wiki.archlinux.org/index.php/Very_Secure_FTP_Daemon

VSFTP http://unix.stackexchange.com/questions/7740/default-file-permissions-ubuntu-vsftpd
"

Also, this was SSIS 2008. My apologies for posting in the SSIS 2012 forum. One of the Mods may want to move it.
Go to Top of Page
   

- Advertisement -