SSIS Catalog FTP & Firewall

Question

Post reply

SSIS Catalog FTP & Firewall

joseph.caldwell

SSC Veteran

Points: 293
More actions
October 3, 2014 at 9:52 am

#291293

I am running a package in the catalog. The package contains a c# script that uses FTP webrequest. It runs fine in SSDT. Trying to execute from the catalog the ftp list directory is timing out.
This seems to be a firewall issue. We have tried adding an exception for dtexec, but that did not help. I am thinking another program runs the package, maybe ISServer.exe?
Does anyone have an idea of the program that would need the firewall exception to run the package in the catalog?
I have searched the web but can not find this.

Viewing 7 posts - 1 through 6 (of 6 total)

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

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

When you run your package in SSDT, are you using Windows Authentication?

I'm guessing you have access to the FTP site and that's why it is working.

When you run in the catalog, is it running as another account? Does that account have access to the FTP site?

joseph.caldwell SSC Veteran Points: 293 More actions · Answer 2

Hi

Thank you for answering. We are using standard FTP with a user name and password. It works with filezilla.

The process times out on the following line of code. Originally, in SSDT, I would have the same problem. Once I added a firewall exception for VSHost.exe the problem was solved.

I am hoping this is the same problem and I just need to add an exception for the process that runs SSIS packages on the server.

joseph.caldwell SSC Veteran Points: 293 More actions · Answer 3

Here is the code.

EnterLog("GetFileList");

reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri(FtpAddress));

reqFTP.UseBinary = true;

reqFTP.UsePassive = false;

EnterLog(FtpUserName + " " + FtpPassword);

reqFTP.Credentials = new NetworkCredential(FtpUserName, FtpPassword);

reqFTP.Method = WebRequestMethods.Ftp.ListDirectory;

EnterLog("Call list dir");

WebResponse response = reqFTP.GetResponse();

EnterLog("Call reader");

StreamReader reader = new StreamReader(response.GetResponseStream());

My last log entry before the timeout is below so I know the getresponsestream is timing out.

EnterLog("Call list dir");

joseph.caldwell SSC Veteran Points: 293 More actions · Answer 4

ISServer.exe is the program that needed the firewall port open. That was to right click the project under SSIS catalog node.

Now trying to run under SQL agent I get the same problem. When launched under an agent, does a different program run and need the exception?

Koen Verbeeck SSC Guru Points: 259135 More actions · Answer 5

I believe it is ISServerExec.exe.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

joseph.caldwell SSC Veteran Points: 293 More actions · Answer 6

ISServer.exe was the program if you run from SSMS. Still have issue running as an agent, either scripted as TSQL (I get rights issues with network drives) or as SSIS package type (FTP timeout issue).