SQL 2008 SSIS FTP Connection through Firewall

  • Hi

    I have a SQL 2008 SSIS Package with an FTP connection in it so I can FTP files to a third party company over the Internet.

    The FTP connection is set to not use Passive mode and runs fine in BIDS on my development machine. It also runs fine on the server after being deployed provided it is run via DTEXECUI (Execute PAckage Utility). The server is a hyper-v virtual server Windows Server Enterprise 2007 SP2.

    Initially the package wouldn't even run via the Execute Package Utility until we added DTEXEC and DTEXECUT to the firewall exceptions list. However if I try to run the package on the SQL Agent queue it refuses to work.

    I get the error:

    Microsoft (R) SQL Server Execute Package Utility

    Version 10.0.2531.0 for 64-bit

    Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 14:19:04

    Error: 2009-12-04 14:24:05.61

    Code: 0xC001602A

    Source: SfnFTP Connection manager "FTP Connection Manager"

    Description: An error occurred in the requested FTP operation. Detailed error description: 425 Can't open data connection.

    421 Timeout (120 seconds): closing control connection.

    421 Terminating connection.

    .

    End Error

    Error: 2009-12-04 14:24:05.63

    Code: 0xC002918B

    Source: FTP Task FTP Task

    Description: Unable to send files using "FTP Connection Manager".

    End Error

    DTExec: The package execution returned DTSER_FAILURE (1).

    Started: 14:19:04

    Finished: 14:24:05

    Elapsed: 300.687 seconds

    I've proved its the firewall as the package and FTP will run if the server Firewall is turned off. I've tried adding the SQL Agent to the firewall exceptions list but that didn't help.

    What else do I need to do to the firewall so the package will run on the SQL agent Queue? Any ideas out there??

  • It likely DTExec that's actually getting blocked.

  • I'm guessing here and it may be nothing, but could you have added the 32 bit version of DTExec to the firewall rules?

    MCITP SQL Server 2005/2008 DBA/DBD

Viewing 3 posts - 1 through 2 (of 2 total)

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