December 4, 2009 at 8:47 am
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??
September 13, 2010 at 1:37 pm
It likely DTExec that's actually getting blocked.
September 13, 2010 at 3:44 pm
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