<div>
<div class="content wysiwyg-content">
using the SSIS feature of SQL Server to do FTP Transfer, what ports would need to be open between SQL Server and the FTP site?<br />
<br />
in one instance, the SQL server (SSIS) will be putting the file into the secured FTP site &nbsp;using id and password. at another time, it will need to read the file from FTP site and bring it down to this side.<br />
<br />
what port are needed to be opened? will it be only on the SQL Server?
</div>
</div>


using the SSIS feature of SQL Server to do FTP Transfer, what ports would need to be open between SQL Server and the FTP site?

in one instance, the SQL server (SSIS) will be putting the file into the secured FTP site  using id and password. at another time, it will need to read the file from FTP site and bring it down to this side.

what port are needed to be opened? will it be only on the SQL Server?

sql server ftp - needed ports opened in windows server 2008R2

A router is a networking device that forwards data packets between computer networks. Routers perform the "traffic directing" functions on the Internet. The most familiar type of routers are home and small office cable or DSL routers that simply pass data, such as web pages, email, IM, and videos between computers and the Internet. More sophisticated routers, such as enterprise routers, connect large business or ISP networks up to the powerful core routers that forward data at high speed along the optical fiber lines of the Internet backbone. Though routers are typically dedicated hardware devices, use of software-based routers has grown increasingly common.

Routers

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.