If you want to learn about the SSIS FTP task, you can read An overview of the SSIS FTP Task articleįirst, let us create an SSIS package. To do that, we are going to use the SSIS FTP Task. Want to learn about Foreach Loop Container, you can read SSIS Foreach Loop vs For Loop Container article To do that, we are going to use SSIS Foreach Loop Container. To upload the file, we require a fully qualified name of the file. Get the list of the file that is going to be uploaded on the FTP Site. This task is going to be performed by the SSIS Backup Database Task Generate the backup of the AdventureWorks2017 database. The backup file is located on the directory. Generated a backup of the AdventureWorks2017 database. Hostname is SAN.Dc.Local.SQL Server Data Tool, 2017.įor the demonstration, we are going to upload the backup of the AdventureWorks2017 database to the FTP Site.
The IP Address of the FTP Site is 192.168.0.130, and the I have configured an FTP site on a virtual machine. In this article, I am going to explain how we can upload the backup file to an FTP Server using the SSIS FTP task.įor the demonstration, I have installed SQL Server 2017 on my workstation and restored the AdventureWorks2017
