SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS FTP to Linux server - CHMOD
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Van
Constraint Violating Yak Guru

458 Posts

Posted - 08/14/2013 :  14:55:09  Show Profile  Reply with Quote
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

458 Posts

Posted - 08/15/2013 :  11:20:49  Show Profile  Reply with Quote
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.

Edited by - Van on 08/15/2013 11:23:43
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000