dbTalk Databases Forums  

SSIS FTP Task -- Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS FTP Task -- Problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vishwanathan Raman
 
Posts: n/a

Default SSIS FTP Task -- Problem - 11-03-2009 , 04:57 AM






I am attempting to send files from Windows to linux ftp. I am getting this
error message which I am not able to understand. I have tried all the options
but have run out of them.

[Connection manager "FTP Connection Manager"] Error: An error occurred in
the requested FTP operation. Detailed error description: 200 Type set to A
227 Entering Passive Mode (207,217,96,15,230,200). 550
/share/RLD/Dev_Files/Case_ATL_20090101.txt: Forbidden filename .

My Remote Path is a variable and is defined as "/share/RLD/Dev_Files/"

My recieve is working fine.

Please help.

Reply With Quote
  #2  
Old   
Todd C
 
Posts: n/a

Default RE: SSIS FTP Task -- Problem - 11-03-2009 , 08:27 AM






I think the key is found in the last two words of your error message:
"Forbidden filename"

If you are using variables to determine location and/or filename, then set a
breakpoint on the "On Pre Execute" event of the FTP task in question and
examine the contents of the variable(s) before the task executes.

Remember that if you are using expressions to set the contents of a
varialbe, and you have literals in the expression, you need to watch for any
reserved character and properly 'escape' it. So, for example, you might need
to have the following:

"\\\\MyShareName\\MyfolderName\\" + [User::FileName]

I noticed your path has forward slashed instead of back slashes. Is that a
Linux thing? Do you need to double up the slash before "share"?

HTH
=====
Todd C


"Vishwanathan Raman" wrote:

Quote:
I am attempting to send files from Windows to linux ftp. I am getting this
error message which I am not able to understand. I have tried all the options
but have run out of them.

[Connection manager "FTP Connection Manager"] Error: An error occurred in
the requested FTP operation. Detailed error description: 200 Type set to A
227 Entering Passive Mode (207,217,96,15,230,200). 550
/share/RLD/Dev_Files/Case_ATL_20090101.txt: Forbidden filename .

My Remote Path is a variable and is defined as "/share/RLD/Dev_Files/"

My recieve is working fine.

Please help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.