SSIS FTP Task never completes

Question

Post reply

SSIS FTP Task never completes

Tim Januario

SSChasing Mays

Points: 609
More actions
November 7, 2006 at 9:02 am

#153277

I'm trying to run an FTP task to pull a file. I have tried both a network address and a local address as the destination. In both cases, the ftp task downloads the file to the correct location. The problem is, that the task never finishes so the next step never runs and the package never completes. If I call the process, the file that was downloaded is complete and can be used.
Does anybody have any idea what may be wrong?
November 10, 2006 at 8:00 am

This was removed by the editor as SPAM

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

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

Andi Punch Valued Member Points: 67 More actions · Answer 1

The same problem occurs to me.

The file has 22.267.288 Bytes

The file retrieved via SSIS FTP Task has 22,267,000 bytes

Any help would be appreciated.

Crispin Proctor SSCoach Points: 18161 More actions · Answer 2

I'm guessing using it with a normal client such as filezilla works fine?

On the ftp server, can you see open connections?

I would hazard a guess that it's an issue with the ftp server and not the client (Shot in the dark) as the second poster's issue was the last couple bytes. Have you tried different ftp servers (as in different server applications)

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Neil Griffiths-347703 SSC Journeyman Points: 89 More actions · Answer 3

I had exactly the same problem, my SSIS package won't move onto the next step after the ftp task.

I changed the chunk size in KB from the default to 1000kb in the ftp connection manager and know I have a consistantly work package, weird???

Neil

rsbaxter17 Valued Member Points: 73 More actions · Answer 4

Neil Griffiths-347703 (12/20/2007)
I had exactly the same problem, my SSIS package won't move onto the next step after the ftp task.
I changed the chunk size in KB from the default to 1000kb in the ftp connection manager and know I have a consistantly work package, weird???
Neil

This worked for me as well. Changed ChunkSize from default 1 to 1000 and the FTP task completed successfully.

DB_Andrew Ten Centuries Points: 1089 More actions · Answer 5

I'm having the same problem. The SSIS package uses the native FTP task to pull down a number of files. It seems random but never gets more then 14 files down of 100+ before it just hangs like it is still running with no error message. I've let it sit for 5+ hours to see if it would do something and nothing. The same SSIS package works fine in under 10 min from my local system in BIDS. It also works great from another server Windows Server 2008 R1 w/ SQL Server 2005 Standard SP3 (9.0.4053)but that sql server has a different role and shouldn't be running this SSIS package long term. I recently moved the package to a Windows Server 2008 R2 box w/ SQL Server 2005 Standard SP3 (9.0.4053) and that is when it quit working. I'm currently looking into .Netframework updates to resolve the issue. I will post back if I get it working.

I changed the Chunk size from 1 to 1000 and it still hangs. Some times it hangs on the 2nd file the 7th file the 14th file is the furthest it gets. I have 100+ files that very in size from 4kb to 300kb. The size of the file doesn't seem to matter. Again this works fine from my workstation in BIDS and two different SQL Servers one with W. Server 2003 and another with W. Server 2008 (r1). It fails on the W. Server 2008 R2 server. I've done all of the .Netframework 3.5.1 updates and even upgraded to .Netframework 4 and it still hangs. I'm about to open a case with Microsoft.