{"id":6761,"date":"2019-04-13T05:29:48","date_gmt":"2019-04-13T05:29:48","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=6761"},"modified":"2019-09-11T11:13:09","modified_gmt":"2019-09-11T11:13:09","slug":"ssis-data-load-sql-server-ftp-sftp-split-files-gzip","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/","title":{"rendered":"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3058 size-full alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/a>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 \u2013 SQL Server to FTP\/SFTP (Split Files, GZip).<\/p>\n<p>For demo purpose we will use SQL Server as relational source but you can use same steps for any database engine such as Oracle, MySQL, DB2. In this post we will use\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-csv-file-task\/\" target=\"_blank\" rel=\"noopener\">Export CSV Task<\/a>\u00a0and\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-sftp-task-ftp-ftps\/\" target=\"_blank\" rel=\"noopener\">ZS Secure FTP Task (SFTP, FTP, FTPS)<\/a>\u00a0to achieve desired integration with\u00a0FTP\/SFTP\/FTPS with drag and drop approach. You can also export data to JSON or XML or Excel file to FTP\/SFTP\/FTPS using same techniques (Use\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-json-file-task\/\" target=\"_blank\" rel=\"noopener\">Export JSON Task<\/a>\u00a0 or\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-xml-file-task\/\" target=\"_blank\" rel=\"noopener\">Export XML Task<\/a>\u00a0or\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-excel-file-task\/\" target=\"_blank\" rel=\"noopener\">Export Excel Task<\/a> ).<\/p>\n<p>Our goal is to achieve following things<\/p>\n<ul>\n<li>Extract large amount of data from SQL Server Table or Query and export to CSV files<\/li>\n<li>Generate CSV files in compressed format (*.gz) to speedup upload<\/li>\n<li>Split CSV files by row count<\/li>\n<li>Upload data to FTP\/SFTP\/FTPS using highly parallel manner for maximum speed<\/li>\n<\/ul>\n<p>There are three different ways you can achieve data export to Secure FTP using SSIS.<\/p>\n<ol>\n<li><strong>Method-1 (Fastest)<\/strong>: Use two step process (First export SQL Server data to local files using\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-csv-file-task\/\" target=\"_blank\" rel=\"noopener\">Export Task<\/a>\u00a0and then upload files to Secure FTP using\u00a0 <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-sftp-task-ftp-ftps\/\" target=\"_blank\" rel=\"noopener\">ZS Secure FTP Task (SFTP, FTP, FTPS)<\/a>\u00a0)<\/li>\n<li><strong>Method-2 (Slower)<\/strong>:\u00a0Use\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-csv-file-task\/\" target=\"_blank\" rel=\"noopener\">Export Task<\/a>\u00a0with Secure FTP Connection as Target rather than save to Local files.<\/li>\n<li><strong>Method-3 (Slower)<\/strong>: Use Data flow components like\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-secure-ftp-csv-file-destination\/\" target=\"_blank\" rel=\"noopener\">Secure FTP CSV File Destination<\/a>\u00a0 (for JSON \/ XML \/ EXCEL\u00a0 \u00a0use Method1 or Method2)<\/li>\n<\/ol>\n<p>Each method has its own advantage \/ disadvantage. If you prefer to upload \/ compress \/ split large amount of data then we recommend Method#1 (Two steps). If you have not very huge dataset then you can use Method#2 or Method#3. For Last method you can only use CSV export option (we don\u2019t have JSON\/ XML\u00a0\/ EXCEL Destination for Secure FTP yet \u2013 we may add in future)<\/p>\n<p><strong>Screenshot of SSIS Package<\/strong><\/p>\n<div id=\"attachment_707\" style=\"width: 835px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-server-data-upload-to-amazon-s3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-707\" class=\"size-full wp-image-707\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-server-data-upload-to-amazon-s3.png\" alt=\"Extract SQL Server Data to CSV files in SSIS (Bulk export) and compress\/upload files to Amazon S3 (AWS Cloud)\" width=\"825\" height=\"430\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-server-data-upload-to-amazon-s3.png 825w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-server-data-upload-to-amazon-s3-300x156.png 300w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/a><p id=\"caption-attachment-707\" class=\"wp-caption-text\">Extract SQL Server Data to CSV files in SSIS (Bulk export) Split \/ GZip Compress \/ upload files to FTP\/SFTP\/FTPS<\/p><\/div>\n<h2><span id=\"Method-1_Upload_SQL_data_to_Azure_Blob_in_Two_steps\">Method-1 : Upload SQL data to Secure FTP in Two steps<\/span><\/h2>\n<p>In this section we will see first method (recommended) to upload SQL data to Secure FTP. This is the fastest approach if you have lots of data to upload.\u00a0 In this approach we first create CSV files from SQL Server data on local disk using\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-csv-file-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Export CSV Task<\/a>. After that in second step we upload all files to Secure FTP Storage using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-sftp-task-ftp-ftps\/\" target=\"_blank\" rel=\"noopener\">ZS Secure FTP Task (SFTP, FTP, FTPS)<\/a>.<\/p>\n<h3><span id=\"Step-1_Configure_Source_Connection_in_Export_CSV_Task\">Step-1: Configure Source Connection in Export CSV Task<\/span><\/h3>\n<p>To extract data from SQL Server you can use Export CSV Task. It has many options which makes it possible to split large amount of data into multiple files. You can specify single table or multiple tables as your data source.<\/p>\n<p>For multiple table use vertical bar. e.g.\u00a0 dbo.Customers|dbo.Products|dbo.Orders. When you export this it will create 3 files ( dbo.Customers.csv , dbo.Products.csv, dbo.Orders.csv )<\/p>\n<p><strong>Steps:<\/strong><\/p>\n<ol>\n<li>Drag ZS Export CSV Task from Toolbox<\/li>\n<li>Double click task to configure<\/li>\n<li>From connection drop down select New\u00a0connection option (OLEDB or ADO.net)<\/li>\n<li>Once connection is configured for Source database specify SQL Query to extract data as below\n<div id=\"attachment_705\" style=\"width: 528px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/export-sql-server-table-query-data-to-csv-fast.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-705\" class=\"size-full wp-image-705\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/export-sql-server-table-query-data-to-csv-fast.png\" alt=\"Export SQL Server Table or Query as CSV file (Bulk export in SSIS)\" width=\"518\" height=\"494\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/export-sql-server-table-query-data-to-csv-fast.png 518w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/export-sql-server-table-query-data-to-csv-fast-300x286.png 300w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/a><p id=\"caption-attachment-705\" class=\"wp-caption-text\">Export SQL Server Table or Query as CSV file (Bulk export in SSIS)<\/p><\/div><\/li>\n<li>Now go to target tab. Here you can specify full path for file. e.g. c:\\ssis\\temp\\cust.csv<\/li>\n<\/ol>\n<h3><span id=\"Step-2_Compress_CSV_Files_in_SSIS_GZIP_format_8211_gz\">Step-2: Compress CSV Files in SSIS ( GZIP format \u2013 *.gz )<\/span><\/h3>\n<p>Above steps will export file as CSV format without splitting or compression. But to compress file once exported you can go to Target tab of Export CSV Task and check [<strong>Compress file to *.gz format<\/strong>] option.<\/p>\n<div id=\"attachment_706\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/compress-csv-files-in-ssis.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-706\" class=\"size-full wp-image-706\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/compress-csv-files-in-ssis.png\" alt=\"Compress exported SQL Server data files to GZip ( *.gz) in SSIS Export CSV Task\" width=\"569\" height=\"462\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/compress-csv-files-in-ssis.png 569w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/compress-csv-files-in-ssis-300x244.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/a><p id=\"caption-attachment-706\" class=\"wp-caption-text\">Compress exported SQL Server data files to GZip ( *.gz) in SSIS Export CSV Task<\/p><\/div>\n<h3><span id=\"Step-3_Split_CSV_files_by_row_count_or_data_size_in_SSIS\">Step-3: Split CSV files by row count or data size in SSIS<\/span><\/h3>\n<p>Now lets look at how to split exported CSV files into multiple files so we can upload many files in parallel. Goto Split Options and check [<strong>Enable Split by Size\/Rows<\/strong>]\n<div id=\"attachment_708\" style=\"width: 435px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-split-csv-files-sql-data.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-708\" class=\"size-full wp-image-708\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-split-csv-files-sql-data.png\" alt=\"Using SSIS Split Exported CSV files (Split by row count or size)\" width=\"425\" height=\"489\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-split-csv-files-sql-data.png 425w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-split-csv-files-sql-data-261x300.png 261w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/a><p id=\"caption-attachment-708\" class=\"wp-caption-text\">Using SSIS Split Exported CSV files (Split by row count or size)<\/p><\/div>\n<h3><span id=\"Step-4_Upload_CSV_files_to_Azure_Blob_8211_Using_multi_threaded_option\">Step-4: Upload CSV files to Secure FTP \u2013 Using multi threaded option<\/span><\/h3>\n<p>Now final thing is use <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-sftp-task-ftp-ftps\/\" target=\"_blank\" rel=\"noopener\">ZS Secure FTP Task (SFTP, FTP, FTPS)<\/a>\u00a0to upload files to Secure FTP.<\/p>\n<p><strong>Steps:<\/strong><\/p>\n<ol>\n<li>Drag ZS Secure FTP Task (SFTP, FTP, FTPS) from SSIS toolbox<\/li>\n<li>Double click ZS Secure FTP Task (SFTP, FTP, FTPS) to configure it<\/li>\n<li>Specify Action = Upload Files To FTP Server<\/li>\n<li>Specify Source file path (or pattern) e.g. c:\\SSIS\\temp\\*.*<\/li>\n<li>Now in the Target connection dropdown click [New]<\/li>\n<li>When Connection UI opens Enter your Account, Secret Key (Leave all other parameters default if you not sure)<\/li>\n<li>Click Test and close connection UI<\/li>\n<li>On the Target path on ZS Secure FTP Task (SFTP, FTP, FTPS) enter your bucket and folder path where you want to upload local files. (For example:\u00a0<strong>\/datafolder\/sqldata\/)<\/strong><\/li>\n<li>Click ok and Run package to test full package<\/li>\n<\/ol>\n<h2><span id=\"Method-2_Upload_SQL_data_to_Azure_Blob_without_local_stage_One_step\">Method-2 : Upload SQL data to Secure FTP without local stage (One step)<\/span><\/h2>\n<p>Now let\u2019s change previous approach little bit to send SQL server data directly to FTP\/SFTP\/FTPS without any Landing area on local disk.\u00a0\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-csv-file-task\/\" target=\"_blank\" rel=\"noopener\">Export CSV Task<\/a>\u00a0,\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-json-file-task\/\" target=\"_blank\" rel=\"noopener\">Export JSON Task<\/a>\u00a0,\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-excel-file-task\/\" target=\"_blank\" rel=\"noopener\">Export Excel Task<\/a>\u00a0and\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-export-xml-file-task\/\" target=\"_blank\" rel=\"noopener\">Export XML Task<\/a>\u00a0all of them supports Azure Blob \/ Amazon S3 and Secure FTP (SFTP) connection as target (Only available in\u00a0<strong>Pro Edition<\/strong>). We will use this feature in following section.<\/p>\n<p>This approach helps to avoid any local disk need and it may be useful for security reason for some users. However drawback of this approach is, it wont use parallel threads to upload large amount of data like previous method.<\/p>\n<p>Following change will be needed on Export task to upload SQL data directly to Azure \/ FTP or Amazon storage.<\/p>\n<div id=\"attachment_5252\" style=\"width: 859px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-data-to-s3-csv-compress-gzip.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-5252\" class=\"size-full wp-image-5252\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-data-to-s3-csv-compress-gzip.png\" alt=\"Export SQL data to multiple files to Amazon S3, Azure, Secure FTP (SFTP) in Stream Mode. Compress GZip, Overwrite, Split Options\" width=\"849\" height=\"627\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-data-to-s3-csv-compress-gzip.png 849w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-data-to-s3-csv-compress-gzip-300x222.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-export-sql-data-to-s3-csv-compress-gzip-768x567.png 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/a><p id=\"caption-attachment-5252\" class=\"wp-caption-text\">Export SQL data to multiple files to Amazon S3, Azure Blob, Secure FTP (SFTP) in Stream Mode. Compress GZip, Overwrite, Split Options<\/p><\/div>\n<h2><span id=\"Method-3_Using_Azure_Blob_destination_8211_Generate_Azure_Blob_file_from_any_source\">Method-3 : Using Secure FTP CSV File Destination \u2013 Generate Secure FTP file from any source<\/span><\/h2>\n<p>Now let\u2019s look at third approach to save data from any SSIS Source to FTP\/SFTP\/FTPS file. Advantage of this approach is you are not limited to few source options provided by Export CSV Task. If you have complex data transformation needed in Data Flow before sending data to FTP\/SFTP\/FTPS then use this approach.\u00a0 We will use\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-secure-ftp-csv-file-destination\/\" target=\"_blank\" rel=\"noopener\">Secure FTP CSV File Destination<\/a>\u00a0as below<\/p>\n<ol>\n<li>Drag SSIS Data flow task from toolbox<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7934\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\" alt=\"Drag and Drop SSIS Data Flow Task from SSIS Toolbox\" width=\"460\" height=\"155\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png 460w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task-300x101.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><\/li>\n<li>Create necessary source connection (e.g. OLEDB connection)<\/li>\n<li>Create Secure FTP Connection (Right click in Connection Managers panel in bottom and click New connection and select\u00a0<strong>ZS-SFTP<\/strong>\u00a0type )<\/li>\n<li>Once connection managers are created Go to data flow designer and Drag OLEDB Source<\/li>\n<li>Configure OLEDB Source to read desired data from source system (e.g. SQL Server \/ Oracle)<\/li>\n<li>Once source is configured drag <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-secure-ftp-csv-file-destination\/\" target=\"_blank\" rel=\"noopener\">ZS Secure FTP CSV File Destination<\/a>\u00a0from SSIS toolbox<\/li>\n<li>Double click Secure FTP CSV File Destination and configure as below\n<ol>\n<li>On Connection Managers tab select Secure FTP Connection (We created in earlier section).<\/li>\n<li>Properties tab configure like below screenshot<\/li>\n<li>On Input Columns tab select desired column you like to write in the target file. Your name from upstream will be taken as is for target file. So make sure to name upstream columns correctly.<\/li>\n<li>Click OK to save UI<\/li>\n<\/ol>\n<\/li>\n<li>Execute package and check your Secure FTP to see files got created.\n<div id=\"attachment_5253\" style=\"width: 729px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-amazon-s3-csv-destination-split-compress-gzip-options.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-5253\" class=\"size-full wp-image-5253\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-amazon-s3-csv-destination-split-compress-gzip-options.png\" alt=\"Loading SQL Server data into S3 Bucket Files (Split, Compress Gzip Options) - SSIS Amazon S3 CSV File Destination\" width=\"719\" height=\"782\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-amazon-s3-csv-destination-split-compress-gzip-options.png 719w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/07\/ssis-amazon-s3-csv-destination-split-compress-gzip-options-276x300.png 276w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/a><p id=\"caption-attachment-5253\" class=\"wp-caption-text\">Loading SQL Server data into Secure FTP Files (Split, Compress Gzip Options) &#8211; SSIS Secure Ftp CSV File Destination<\/p><\/div><\/li>\n<\/ol>\n<h2><span id=\"Conclusion\">Conclusion<\/span><\/h2>\n<p>In this post you have seen how easy it is to upload \/ archive your SQL Server data (or any other RDBMS data) to FTP\/SFTP\/FTPS in few clicks.\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">Try SSIS PowerPack<\/a>\u00a0for free and\u00a0find out yourself how easy it is to integrate SQL Server and Secure FTP using SSIS.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 \u2013 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 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":3058,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127,20,94,461,138,137],"tags":[128,296,295,481,294,12],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-04-13T05:29:48+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-09-11T11:13:09+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"100\" \/>\r\n\t<meta property=\"og:image:height\" content=\"100\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/\",\"name\":\"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\",\"datePublished\":\"2019-04-13T05:29:48+00:00\",\"dateModified\":\"2019-09-11T11:13:09+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png\",\"width\":100,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/hshah\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog","description":"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog","og_description":"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)","og_url":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/","og_site_name":"ZappySys Blog","article_published_time":"2019-04-13T05:29:48+00:00","article_modified_time":"2019-09-11T11:13:09+00:00","og_image":[{"width":100,"height":100,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/","url":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/","name":"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png","datePublished":"2019-04-13T05:29:48+00:00","dateModified":"2019-09-11T11:13:09+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"Learn how to load large amount of data from SQL Server to FTP\/SFTP. SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-sftp-ftp-ftps-task.png","width":100,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-data-load-sql-server-ftp-sftp-split-files-gzip\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Data Load \u2013 SQL Server to FTP\/SFTP (Split Files, GZip)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","caption":"ZappySys"},"url":"https:\/\/zappysys.com\/blog\/author\/hshah\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6761"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=6761"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6761\/revisions"}],"predecessor-version":[{"id":7948,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6761\/revisions\/7948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/3058"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=6761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=6761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=6761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}