I have several files to download on an FTP server. When I run the task alone, in BIDS it works. When I run the package in BIDS, I get an error below. It seems to be happening on a big file. I changed the CHUNK SIZE to 1000 but still the same issues. I was thinking of writing an ftp script as a work around instead of using the FTP task. Error: 0xC002918A at FTP Get BI Files, FTP Task: Unable to receive files using "AEROFTP1 FTP Conn". Task failed: FTP Get BI Files Warning: 0x80019002 at KWI Business Intelligence: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "KWI Business Intelligence.dtsx" finished: Failure.

It is just a warning, why not to increase the MaxErrorCount to be greater than 1?Arthur My Blog

You're saying that it works if you right-click the FTP Task and select Execute, but doesn't work if you right-click the package in Solution Explorer and select Execute? Do you have any configurations in the package? Do you have any expressions on the FTP Connection Manager or FTP Task? Talk to me now on

It is just a warning, why not to increase the MaxErrorCount to be greater than 1? Arthur My Blog Nope - didn't work.

You're saying that it works if you right-click the FTP Task and select Execute, but doesn't work if you right-click the package in Solution Explorer and select Execute? Do you have any configurations in the package? Do you have any expressions on the FTP Connection Manager or FTP Task? Talk to me now on Yes it works perfectly when I right click on the FTP Task but fails if I execute the whole package. It starts downloading files then stops when it encounters a large file. I don't have expressions. It's pretty straight forward, get me these files---> /folder/bi/KWI-MBS*.TXT

Do you have any other tasks running concurrently? If there are large files on the FTP server, does it still work when you execute the single task only? Do you have package configurations? Talk to me now on

No tasks running concurrently. It always works when I execute the single task. I even created a package with only an FTP task. It always works when I execute the task. It fails when I execute the package. I don't know if this has anything to do with it but my SQL server (running SSIS) is virtual as well as the FTP server.

Since this is the Virtual Box I think you need to increase the memory pool available (you even said it fails on a large file). What virtual server solution do you use?Arthur My Blog

Tha VM admin increased the memory x2. Same issue.

Tha VM admin increased the memory x2. Same issue.

Tha VM admin increased the memory x2. Same issue.

Are there any kind of log files you can examine on the FTP server side? Perhaps it can explain something different about the connection. You may also want to try some FTP actions through .Net code via a Script Task. This is commonly done to do things like get a list of file names from the FTP server, not to actually retrieve the files, but it could operate differently. Here's a sample. Talk to me now on

Also see what I found in our Forum: http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/2e29afca-40b2-4f97-861b-5c12970e3ff0 It could be simply say an incorrect path in the FTP Task somehow, possibly you are using a config file in which you did a typo, didn't you?Arthur My Blog