Post reply

Unable to Send Files to FTP Server

  • February 16, 2009 at 1:27 am

    #134806

    Hi,

    Sorry if the topic already exists.

    I want to process an excel report and send the file to FTP server.

    I can receive file from the FTP server but unable to send it to it. But I can copy & paste the file to the location, so I think there is no permission issue.

    After execution, I get the following error as

    =======================================================================

    [Connection manager "{E48D978F-8F62-42B6-9F06-DE3DD7444A5D}"] Error: 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. .

    ========================================================================

    I just cant understand the error and its root cause.

    I use the following code in Script Task

    ---------------------------------------------------------------------------------------------

    Try

    Dim cm As ConnectionManager = Dts.Connections.Add("FTP")

    cm.Properties("ServerName").SetValue(cm, Dts.Variables("ftpServerName").Value.ToString)

    cm.Properties("ServerUserName").SetValue(cm, Dts.Variables("ftpUserName").Value.ToString)

    cm.Properties("ServerPassword").SetValue(cm, Dts.Variables("ftpPassword").Value.ToString)

    cm.Properties("ServerPort").SetValue(cm, "21")

    cm.Properties("Timeout").SetValue(cm, "0") 'The 0 setting will make it not timeout

    cm.Properties("ChunkSize").SetValue(cm, "1000") '1000 kb

    cm.Properties("Retries").SetValue(cm, "1")

    Dim ftp As FtpClientConnection = New FtpClientConnection(cm.AcquireConnection(Nothing))

    http://ftp.Connect()

    Dim files(0) As String

    files(0) = "C:\MTOrders.xls"

    http://ftp.SendFiles(files, "//MTOrders.xls", True, False)

    http://ftp.Close()

    Catch ex As Exception

    Dts.TaskResult = Dts.Results.Failure

    End Try

    ------------------------------------------------------------------------------------------------

    Please help me in solving this issue.

    Thanks in advance.

    Priya

    Regards
    Priya

  • February 16, 2009 at 6:34 am

    #944479

    Is there any reason why you are scripting this task and not using the FTP Task in SSIS?

  • February 16, 2009 at 8:12 am

    #944572

    Nothing specific. When Replaced Script task with the FTP Task

    I get the following error

    [FTP Task] Error: Unable to connect to FTP server using "FTP Connection Manager".

    But the FTP test connection succeeded and fails when executing the package.

    I use the remote path value as

    "\Abc.xls"

    Local path value is

    "C:\FTPFiles\Abc.xls"

    Should i want to change anything. Also I increased the Chunk size to 1000 KB.

    Just cant recognize the root cause. Please help

    Thanks in advance.

    Priya

    Regards
    Priya

  • February 16, 2009 at 8:19 am

    #944577

    The same error occurs for the FTP task also

    [Connection manager "FTP Connection Manager"] Error: 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. .

    Regards
    Priya

  • February 16, 2009 at 8:31 am

    #944592

    By the rerror message it looks as if the server + firewall combination of the FTP server are rejecting the connection, not that there is anything wrong with your connection specs. The PORT command and PASV commands are used to open up communication for reading and writing data.

    I would try connecting with an FTP client outside of your SSIS package to see what properties you need to set (I find Flash FXP good for this but there are lots of free ones on the mkt) and check the logs on the FTP server (if there are any) to see why the connection is not getting through.

    You can also check firewall settings (if there is a firewall in between) to see if any ports are blocked, and what messages are being reported there.

  • February 16, 2009 at 9:01 am

    #944629

    Thanks again. If the firewalls are enabled, does it allow me to manually Copy & paste the same file?

    I can Copy/Paste the same file to the FTP Server manually.

    Can you please explain this possibility?

    Also, Is there any possibility for me to check the FTP log?

    I m connecting using ftp://abc.ftpserver.com/ with a username and a password.

    Please help

    Priya

    Regards
    Priya

  • February 16, 2009 at 9:55 am

    #944685

    Hi,

    Thank u so much. I can upload now.

    The problem is that "I shouldn't specify the remote file name. only "/" in remote file succeeds sending file to ftp server"

    Thanks again.

    Priya

    Regards
    Priya

  • February 17, 2009 at 9:08 am

    #945267

    Glad you solved your problem (and I learned from it) but what about the case where you want to specify another name for the destination file?

  • February 19, 2009 at 3:39 am

    #946541

    Hi,

    Sorry for the late response.

    When tried to change the FTP file name in command prompt using

    send abc.xls Newabc.xls

    This is successful in command prompt but gives me errors in the FTP task.

    Priya....

    Regards
    Priya

  • March 12, 2009 at 9:42 am

    #958444

    I am having the same FTP error using a FTP task a part of a bigger ssis package. torubleshooting steps -

    * Using an FTP client, I was successful

    * Testing the SSIS FTP connection manager manually was successful

    * Tried specifing my remote path through a variable and outside of a variable = failure

    I have read this thread but I can't get my FTP task to work

  • March 12, 2009 at 9:45 am

    #958449

    Hi,

    Sorry if i m wrong. Please try specifying "/" for ur remote path. It should succeed.

    Regards
    Priya

  • April 2, 2009 at 7:07 am

    #970632

    I'm having problems with my FTP task on SSIS as well. it's quite different from everything i have seen so far on the forum.

    background ...

    within my package i have a data flow task; which contains 7 instances of OLE DB source+ flat file destinations. this pulls data from 7 different databases into existing csv files.

    i also have an execute process task which merges each of the files with a fixed header csv file

    then i have 7 FTP tasks; each sending a file (from above) to a corresponding folder on the ftp server.

    the problem is this;

    when debugging, the data flow task, the execute process task and some FTP tasks succeed. the failures always stem from the FTP tasks, it is however very random; FTP1 and FTP3 could fail while every other thing succeeds or FTP7 and FTP4 could fail while all others succeed.

    on a few occasions i get this error 'Error: 0xC001602A at Package, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: 200 Switching to Binary mode.

    200 PORT command successful. Consider using PASV.

    425 Use PORT or PASV first.'

    on others; 'Error: 0xC001602A at Package, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The operation has been canceled

    .

    Error: 0xC002918F at FTP TaskPoland, FTP Task: Unable to connect to FTP server using "FTP Connection Manager".'

    any help would be greatly appreciated.

    thanks

    ------------------------------------------------------------------------
    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 23, 2009 at 4:15 am

    #982741

    i have resolved the problem, it was a precedence issue. because MaxConcurrentExecutables was set to -1, it can only execute 2 tasks concurrently successfully and i had seven. there are two ways around it; 1) increase the value for MaxConcurrentExecutables or redo the execution precedence.

    ------------------------------------------------------------------------
    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 23, 2009 at 6:12 am

    #982791

    Excuse a (probably) dumb question:

    Where is MaxConcurrentExecutables, and why does -1 not mean unlimited?

  • April 23, 2009 at 6:24 am

    #982804

    Jim Russell (4/23/2009)

    Excuse a (probably) dumb question

    not a dumb question Jim, we all learn daily.

    Where is MaxConcurrentExecutables,

    MaxConcurrentExecutables is one of the package properties, so if you click on the design window you'll find it in the properties tab.

    and why does -1 not mean unlimited?

    i don't know the answer to that, but i found out about it on one of the training videos on this site.

    ------------------------------------------------------------------------
    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 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply