November 3, 2009 at 10:40 am
Hi guys
I have an interesting problem that has left me confused. I am uploading files to an FTP site using variables in a foreach loop. The for each loop is working fine, but the actual ftp load isnt. The error i get get is the destination path is incorrect, yet it works if i were to manually navigate there using IE. I know that when logging into an FTP dirtectory you actually logging into a default directory set up for the username and password supplied. (grasping at straws i know..) is it possible that when SSIS logs in using these credentials it sees the full path that i cant see in IE, giving me ? I have done FTP tasks through SSIS in much the same way before, this this problem makes no sense. Any help welcome;-)
Thanx.
November 3, 2009 at 2:38 pm
what security context is the SSIS package running ? what user and does that user have rights to that folder? do you have folder names longer than 8 characters in that ftp?
November 4, 2009 at 3:48 am
Currently SSIS package security context is sa. the issue isnt retrieving the data from the Db its the FTP file path where i want to place the file thats giving me trouble. FTP directory names do exceed 8 characters, max being 11. Thanx for the help so far..
November 4, 2009 at 7:40 am
No worris, i got it right. It was the FTP path. Thanx for the help..:-D
November 4, 2009 at 7:47 am
No Worries, i got it.It was the file path. Thanx.:-D
Viewing 5 posts - 1 through 4 (of 4 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