<div>
<div class="content wysiwyg-content">
I am transfering a large file ~500MB from one server to another via a FTP Task inside of a SQL Server 2000 DTS package. &nbsp;During execution I can see the destination file growing however at varying times the FTP task stops and eventually fails. &nbsp;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? &nbsp; 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. &nbsp;Could there be a setting on my FTP server that I am missing?<br />
Environment:<br />
Windows 2003 Server --&gt; Windows 2003 Server<br />
transferring ~500MB text file<br />
<br />
Any ideas?
</div>
</div>


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?
Environment:
Windows 2003 Server --> Windows 2003 Server
transferring ~500MB text file

Any ideas?

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

A server is a computer program or a machine that waits for requests from other machines or software (clients) and responds to them. This architecture is called the client–server model. The clients may run on the same computer or may connect to the server over a network. The purpose of a server is to share data or hardware and software resources among clients. Typical computing servers are database servers, file servers, mail servers, print servers, web servers, game servers, and application servers.

Server Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.