April 28, 2009 at 8:13 am
i have noticed an FTP task succeeds when the remote path location is set to '/', but the moment it goes beyond the root folder, it fails (with my package). the ftp server is a linux machine.
does anyone have any idea why and how to go around this? i really need to put these files into a particular folder in the root directory.
cheers
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 28, 2009 at 8:20 am
What's the error message?
April 28, 2009 at 8:26 am
here's the error
Error: 0xC001602A at Package, Connection manager "FTP Connection Manager 1": An error occurred in the requested FTP operation. Detailed error description: 200 Switching to Binary mode.
200 PORT command successful. Consider using PASV.
553 Could not create file.
Error: 0xC002918B at FTP Poland, FTP Task: Unable to send files using "FTP Connection Manager 1".
Task failed: FTP Poland
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 28, 2009 at 8:32 am
This looks like a permissions issue on the FTP server. Using the same account as the SSIS package, are you able to create a file using an FTP client?
April 28, 2009 at 8:38 am
yes i am.
about the permissions issue, i'm a bit confused, here's why; sometimes it works fine other times it fails (when sending files to a folder in the root directory), but it always succeeds when sending directly into the root directory. i don't have any linux security knowledge, so i'd really appreciate any insight into this.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 28, 2009 at 8:41 am
If it works some of the time, it's not permissions related.
You may or may not know that Linux is case-sensitive for file and folder names. Is it possible that you're not consistently providing the target folder name with the correct case?
April 28, 2009 at 8:46 am
i am aware of the sensitivity of linux to cases and have taken great care with regards to that. the folder/file names are consistent and match accurately.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy