FTP Task not completing on SQL Server 2000 DTS Package, size limit?  time limit?

Posted on 2008-02-07
Medium Priority
Last Modified: 2013-12-02
I am transfering a large file ~500MB from one server to another via a FTP Task inside of a SQL Server 2000 DTS package.  During execution I can see the destination file growing however at varying times the FTP task stops and eventually fails.  I'm wondering is there a file size limit for this type of task or is there a time limit on how quickly the file has to me moved over?   Using a FTP stand-alone program the file usually takes 1hr40min to transfer however even the stand-alone program doesn't always transfer the entire file without erroring out.  Could there be a setting on my FTP server that I am missing?
Windows 2003 Server --> Windows 2003 Server
transferring ~500MB text file

Any ideas?
Question by:irishski
1 Comment
LVL 25

Accepted Solution

jogos earned 1500 total points
ID: 20848547
Unreliable connection? So the larger files you transmit the more chanses on errors.
You can give it a try to transfer the a zipped version of your file and transfer it 'binary'.

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
Media Temple is thrilled to announce the launch of our new Partner Program, specifically designed to empower digital agencies and adtech platforms by offering white-glove support and exclusive hosting enhancements to optimize their sites and their c…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question