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