Introduction In this blog post you will see how easy it is to load large amount of data from SQL Server to FTP/SFTP. SSIS Data Load – SQL Server to FTP/SFTP (Split Files, GZip). For demo purpose we will use SQL Server as relational source but you can use same steps for any database engine […]
Category Archives: SSIS SFTP / FTP Connection
Articles about SSIS Secure FTP Storage Connection Manager to connect to files stored in FTP Storage using SFTP / FTPS / FTP. Securly Read / Write files in FTP and manage (Create, Delete, List).
Read SFTP / FTP Files in SSIS (CSV, JSON, XML)
Introduction In our previous blog, we saw how to perform SFTP / FTP File Operations in SSIS. Now in this blog, we will see How to Read SFTP / FTP Files in SSIS (CSV, JSON, XML Format files). To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources […]