{"id":1097,"date":"2017-04-19T21:40:45","date_gmt":"2017-04-19T21:40:45","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=1097"},"modified":"2017-04-19T21:47:35","modified_gmt":"2017-04-19T21:47:35","slug":"ssis-copy-move-amazon-s3-files-from-aws-to-azure","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/","title":{"rendered":"SSIS &#8211; Copy Amazon S3 files from AWS to Azure"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Azure and AWS both are most popular Cloud Platforms. In this blog post we will learn <em>how to copy or move Amazon S3 files to Azure Blob Storage<\/em>\u00a0without any coding or scripting \u00a0(<strong>AWS to Azure File Copy \/ Migration Scenario<\/strong>). To achieve this objective we will use following Drag and Drop SSIS \u00a0Tasks (i.e. Microsoft SQL Server Integration Services &#8211; <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/sql-server-integration-services\" target=\"_blank\">ETL Platform for SQL Server<\/a>). Following components are highly optimized for parallel copy\/multi threading with secure connection (client side\/serverside encryption).<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-storage-task\/ssis-azure-cloud-storage-task.png\" alt=\"Custom SSIS Tasks - Azure Blob Storage Task\" width=\"32\" \/><\/td>\n<td><a title=\"SSIS Azure Blob Storage Task (Manage Azure Blob Storage)\" href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-blob-storage-task\/\" target=\"_blank\">SSIS Azure Blob Storage Task<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><img decoding=\"async\" src=\"\/\/zappysys.com\/images\/ssis-powerpack\/SSIS-Amazon-S3-Cloud-Task.png\" alt=\"Custom SSIS Components - Amazon S3 Task (AWS S3)\" width=\"32\" \/><\/td>\n<td><a title=\"SSIS Amazon Storage Task (Manage AWS S3)\" href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\">SSIS Amazon Storage Task (AWS S3)<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Concept : Fast Server Side Copy in Azure (Copy files into Azure Blob Storage)<\/h2>\n<p>Azure provides unique feature called server side file copy. Using this feature you can load or copy files into Azure Blob Storage without landing data to your local machine. As of now (March 2017) this type of feature is still missing in other Cloud Platform such as <strong>Amazon AWS<\/strong> and <strong>Google Cloud Platform &#8211; GCP<\/strong>.<\/p>\n<p>Using server side copy feature in Azure&#8230; you can achieve following scenarios in SSIS without coding<\/p>\n<ul>\n<li>Move \/ Copy files from Amazon S3 to Azure Blob Storage<\/li>\n<li>Move \/\u00a0Copy files from Google Cloud Platform (GCP) to\u00a0Azure Blob Storage<\/li>\n<li>Copy files from any public URL to\u00a0Azure Blob Storage (Assuming URL doesn&#8217;t require credentials or its intranet URL)<\/li>\n<\/ul>\n<p>In first two scenarios you need to have Source File URL using Authentication information inside URL (This is called Pre-Signed URL e.g. http:\/\/mycloud.com\/myfile.zip?SIGNATURE-GOES-HERE ). All major Cloud Providers Support Pre-Signed URL so you can securely share files \u00a0with other without sharing your actual Credentials. You can configure Pre-Signed URL to expires in certain time frame (Check your Cloud API documentation). If your file doesn&#8217;t need credentials to access then you don&#8217;t have to worry about Pre-Signed URL. Your source can be file URL \u00a0(E.g. https:\/\/mysite.com\/downloads\/fil1.zip)<\/p>\n<p><strong>Pre-Signed URL for Google Cloud (GCP)<\/strong><br \/>\nHere is more information <a title=\"Create Presigned URL for Google Cloud Platform file (GCP file)\" href=\"https:\/\/cloud.google.com\/storage\/docs\/access-control\/create-signed-urls-gsutil\" target=\"_blank\">how to get Pre-Signed URL for Google Cloud Platform (GCP) <\/a>&#8211; Use gsutil command line<br \/>\n<strong>Pre-Signed URL for Amazon AWS (S3 file)<\/strong><br \/>\nTo create pre-signed URL for AWS S3 files you can use <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\">SSIS Amazon Storage Task<\/a> and use Get Pre-Signed URL Action (Described in the below section). This action supports creating pre-signed URLs for multiple files using wildcard (e.g \/mybkt\/*.zip) \u00a0or you can get single pre-signed URL. If you use pattern search then you will get DataTable back &#8230; which can be loop through using ForEach Loop task (Loop ADO Recordset option) . If you do not use wild card then only one URL returned in string format.<\/p>\n<h2>Prerequisites<\/h2>\n<p>Before we look at next section make sure following\u00a0prerequisites are met<\/p>\n<ol>\n<li>You have obtained Amazon S3 Access Key and Secret Key to access desired files<\/li>\n<li>You have obtained Azure Storage Account Name and Account Key to access desired Blob Container. If you don&#8217;t have access to Azure then you can download Azure Storage Emulator for testing Purpose. <a href=\"https:\/\/zappysys.com\/forums\/topic\/azure-blob-storage-how-to-download-and-test-azure-storage-emulator\/\" target=\"_blank\">Check this<\/a>.<\/li>\n<li>You have basic knowledge of SSIS. If you dont then search for SSIS tutorial and there are many blogs \/ tutorials to get started \ud83d\ude42<\/li>\n<\/ol>\n<h2>Step-By-Step &#8211; Create SSIS Package &#8211; Copy Amazon S3 Files to Azure Blob Storage<\/h2>\n<p>Now lets look at how to copy Amazon S3 files to Azure in few clicks. This approach doesn&#8217;t bring any data to your local system so its purely server to server copy and that is why its very fast and secure.<\/p>\n<ol>\n<li>First Download and <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\">Install SSIS PowerPack<\/a><\/li>\n<li>Once you install SSIS PowerPack. Create a new Sample SSIS Project and open Package<\/li>\n<li>From SSIS Toolbox Drag <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\">ZS Amazon Storage Task<\/a> and drop on Control Flow surface. Rename it to <strong>Get S3 File Urls<\/strong><\/li>\n<li>Double click S3 task to edit. From Action dropdown select (Get Amazon S3 Files Pre-Signed Url Option)<\/li>\n<li>Click New next to the Connection Dropdown to create Amazon Storage Connection. Enter your credentials and bucket region and Click Test. If you are <a href=\"https:\/\/zappysys.com\/blog\/check-amazon-s3-bucket-location-region\/\" target=\"_blank\">not sure about your bucket region then check this article<\/a>.\n<div id=\"attachment_2196\" style=\"width: 647px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-aws-to-azure-copy-create-pre-signed-url-multiple-files.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2196\" class=\"size-full wp-image-2196\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-aws-to-azure-copy-create-pre-signed-url-multiple-files.png\" alt=\"SSIS Amazon Storage Task - Create Pre-Signed URLs for multiple files stored in S3\" width=\"637\" height=\"824\" \/><\/a><p id=\"caption-attachment-2196\" class=\"wp-caption-text\">SSIS Amazon Storage Task &#8211; Create Pre-Signed URLs for multiple files stored in S3<\/p><\/div><\/li>\n<li>Now click on Advanced Tab and check Use region specific endpoint option\n<div id=\"attachment_2197\" style=\"width: 414px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-amazon-s3-connection-region-specific-endpoint.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2197\" class=\"size-full wp-image-2197\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-amazon-s3-connection-region-specific-endpoint.png\" alt=\"SSIS Amazon S3 Connection - Region specific endpoint option\" width=\"404\" height=\"200\" \/><\/a><p id=\"caption-attachment-2197\" class=\"wp-caption-text\">SSIS Amazon S3 Connection &#8211; Region specific endpoint option<\/p><\/div><\/li>\n<li>Once Test connection is green you can click OK to save connection.<\/li>\n<li>Once you back to Amazon Storage Task UI&#8230; Click on browse next to S3 file path. Her you can select one file or enter pattern to create URLs for multiple files.<\/li>\n<li>To save pre-signed URL(s) select Variable. If variable is not there then create new one&#8230; If you enter pattern in Source path then Variable must be Object datatype. For multiple URL it will return ADO Recordset (You can use with ForEach Loop Task). If you didn&#8217;t enter pattern in source path then variable can be string datatype.\n<div id=\"attachment_2198\" style=\"width: 845px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-get-presigned-url-for-multiple-amazon-s3-files-for-loop.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2198\" class=\"size-full wp-image-2198\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-get-presigned-url-for-multiple-amazon-s3-files-for-loop.png\" alt=\"SSIS Amazon Storage Task - Save Pre-Signed URL to Variable (Save Multiple URL as Recordset )\" width=\"835\" height=\"681\" \/><\/a><p id=\"caption-attachment-2198\" class=\"wp-caption-text\">SSIS Amazon Storage Task &#8211; Save Pre-Signed URL to Variable (Save Multiple URL as Recordset )<\/p><\/div><\/li>\n<li>Now drag and drop ForEach Loop Container on the surface and configure like below\n<div id=\"attachment_2199\" style=\"width: 660px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-foreach-loop-amazon-s3-files-presigned-url.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2199\" class=\"size-full wp-image-2199\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-foreach-loop-amazon-s3-files-presigned-url.png\" alt=\"SSIS ForEach Loop Container Task - Loop through Amazon S3 file URL\" width=\"650\" height=\"550\" \/><\/a><p id=\"caption-attachment-2199\" class=\"wp-caption-text\">SSIS ForEach Loop Container Task &#8211; Loop through Amazon S3 file URL<\/p><\/div>\n<div id=\"attachment_2200\" style=\"width: 450px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-foreach-loop-variable-mapping-each-iteration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2200\" class=\"size-full wp-image-2200\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-foreach-loop-variable-mapping-each-iteration.png\" alt=\"SSIS ForEach Loop Task - Variable Mappings\" width=\"440\" height=\"365\" \/><\/a><p id=\"caption-attachment-2200\" class=\"wp-caption-text\">SSIS ForEach Loop Task &#8211; Variable Mappings<\/p><\/div><\/li>\n<li>Once Foreach Loop is configured you can drag <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-blob-storage-task\/\" target=\"_blank\">ZS Azure Storage Task<\/a> inside ForEach Loop Container<\/li>\n<li>Double click Azure storage task and select [<strong>Copy from external file<\/strong>] option from Action dropdown.<\/li>\n<li>In the source Path\/URL we will enter variable name which holds current URL for ForEach Loop iteration. Easy way is click blue variable icon and select &lt;&lt;Insert Variable&gt;&gt;. Your placeholder may look like below.\n<pre>{{User::varCurrentS3Url}}<\/pre>\n<\/li>\n<li>For target path &#8230; Click New Connection to create and configure new <strong>Azure Storage Connection<\/strong> like below. Enter Azure storage credentials and click test. If you don&#8217;t have real Azure credentials then you can use <a href=\"https:\/\/zappysys.com\/forums\/topic\/azure-blob-storage-how-to-download-and-test-azure-storage-emulator\/\" target=\"_blank\">Azure Storage Emulator (Check this)<\/a>.\u00a0Once connection is Configured click Test connection and click OK to save connection.\n<div id=\"attachment_2201\" style=\"width: 898px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-configure-azure-storage-task-copy-aws-s3-file.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2201\" class=\"size-full wp-image-2201\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-configure-azure-storage-task-copy-aws-s3-file.png\" alt=\"Azure Storage Task - Configure Blob Storage connection- Serverside Copy S3 files - AWS to Azure\" width=\"888\" height=\"829\" \/><\/a><p id=\"caption-attachment-2201\" class=\"wp-caption-text\">Azure Storage Task &#8211; Configure Blob Storage connection- Serverside Copy S3 files &#8211; AWS to Azure<\/p><\/div><\/li>\n<li>Once everything is configure you can save package and execute. This will copy S3 files to Azure Blob storage.<\/li>\n<li>Here is execution log\n<pre class=\"\">SSIS package \"C:\\SSIS\\Amazon-To-Azure-Copy.dtsx\" starting.\r\nInformation: 0x0 at Get Signed URL for S3 Files, Get Signed URL for S3 Files: You are running TRIAL version. It will expire in 29 day(s)\r\nInformation: 0x0 at Get Signed URL for S3 Files, Get Signed URL for S3 Files: Reading [PRESIGNED-URL] property for zs-eu-west-2-london-bkt2\/*.*\r\nInformation: 0x0 at Copy S3 File to Azure, Copy S3 File to Azure: Copy started: Source=https:\/\/zs-eu-west-2-london-bkt2.s3.eu-west-2.amazonaws.com\/cloudfile1.csv, Target=test1\/\r\nInformation: 0x0 at Copy S3 File to Azure, Copy S3 File to Azure: Copying https:\/\/zs-eu-west-2-london-bkt2.s3.eu-west-2.amazonaws.com\/cloudfile1.csv ...\r\nInformation: 0x0 at Copy S3 File to Azure, Copy S3 File to Azure: Copy started: Source=https:\/\/zs-eu-west-2-london-bkt2.s3.eu-west-2.amazonaws.com\/cloudfile3.txt, Target=test1\/\r\nInformation: 0x0 at Copy S3 File to Azure, Copy S3 File to Azure: Copying https:\/\/zs-eu-west-2-london-bkt2.s3.eu-west-2.amazonaws.com\/cloudfile3.txt ...\r\nSSIS package \"C:\\SSIS\\Amazon-To-Azure-Copy.dtsx\" finished: Success.<\/pre>\n<div id=\"attachment_1100\" style=\"width: 712px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1100\" class=\"size-full wp-image-1100\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\" alt=\"SSIS Package Execution - Copy Multiple S3 Files from Amazon to Azure\" width=\"702\" height=\"380\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png 702w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure-300x162.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><p id=\"caption-attachment-1100\" class=\"wp-caption-text\">SSIS Package Execution &#8211; Copy Multiple S3 Files from<br \/>Amazon to Azure<\/p><\/div><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>How to move Amazon S3 files to Azure<\/h2>\n<p>In above example you saw how to copy files from Amazon S3 to Azure Blob Storage. But what if you want to Move&#8230; so once file is copied you want to delete from source. In that case its simple. Add one more Amazon S3 Task at the end so if all previous steps successful you can Issue delete files command using ZS Amazon Storage Task.<\/p>\n<div id=\"attachment_2204\" style=\"width: 602px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-delete-amazon-s3-files.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2204\" class=\"size-full wp-image-2204\" src=\"\/\/zappysys.com\/wp-content\/uploads\/2017\/04\/ssis-delete-amazon-s3-files.png\" alt=\"SSIS Delete Amazon S3 Files after Successful S3 to Azure Copy operation (This will mimic Move)\" width=\"592\" height=\"550\" \/><\/a><p id=\"caption-attachment-2204\" class=\"wp-caption-text\">SSIS Delete Amazon S3 Files after Successful S3 to Azure Copy operation (This will mimic Move)<\/p><\/div>\n<h2>Download Sample SSIS Package<\/h2>\n<p><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/SSIS-Amazon-S3-To-Azure-Copy-Move.zip\">Click here to download sample SSIS file for SQL Server 2012, 2014, 2016<\/a><\/p>\n<h2>Conclusion<\/h2>\n<p>If you want to bring data from Amazon S3 to Azure in fastest way then technique described in this article can help you to cut down your data transfer time by several times. <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a> comes with 45+ components and tasks which can give you drag and drop interface for your Cloud connectivity projects. It also comes with many connectors to help with JSON, XML, REST API related integration. Try <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a>\u00a0for FREE without any limitation and find out what else you can do with it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Azure and AWS both are most popular Cloud Platforms. In this blog post we will learn how to copy or move Amazon S3 files to Azure Blob Storage\u00a0without any coding or scripting \u00a0(AWS to Azure File Copy \/ Migration Scenario). To achieve this objective we will use following Drag and Drop SSIS \u00a0Tasks (i.e. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1100,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[181,182],"tags":[77,29,183,184,185,186,12,187,188,4],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS - Copy Amazon S3 files from AWS to Azure | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.\" \/>\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-copy-move-amazon-s3-files-from-aws-to-azure\/\" \/>\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 - Copy Amazon S3 files from AWS to Azure | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-04-19T21:40:45+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2017-04-19T21:47:35+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"702\" \/>\r\n\t<meta property=\"og:image:height\" content=\"380\" \/>\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:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\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-copy-move-amazon-s3-files-from-aws-to-azure\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/\",\"name\":\"SSIS - Copy Amazon S3 files from AWS to Azure | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\",\"datePublished\":\"2017-04-19T21:40:45+00:00\",\"dateModified\":\"2017-04-19T21:47:35+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png\",\"width\":702,\"height\":380,\"caption\":\"SSIS Package Execution - Copy Multiple S3 Files from Amazon to Azure\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS &#8211; Copy Amazon S3 files from AWS to Azure\"}]},{\"@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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS - Copy Amazon S3 files from AWS to Azure | ZappySys Blog","description":"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.","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-copy-move-amazon-s3-files-from-aws-to-azure\/","og_locale":"en_US","og_type":"article","og_title":"SSIS - Copy Amazon S3 files from AWS to Azure | ZappySys Blog","og_description":"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.","og_url":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-04-19T21:40:45+00:00","article_modified_time":"2017-04-19T21:47:35+00:00","og_image":[{"width":702,"height":380,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/","url":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/","name":"SSIS - Copy Amazon S3 files from AWS to Azure | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png","datePublished":"2017-04-19T21:40:45+00:00","dateModified":"2017-04-19T21:47:35+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to copy or move Amazon S3 files from AWS to Azure without any scripting. It uses Azure Server side copy feature so no local resource used.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/ssis-package-copy-multiple-s3-files-amazon-aws-to-azure.png","width":702,"height":380,"caption":"SSIS Package Execution - Copy Multiple S3 Files from Amazon to Azure"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-copy-move-amazon-s3-files-from-aws-to-azure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS &#8211; Copy Amazon S3 files from AWS to Azure"}]},{"@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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1097"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=1097"}],"version-history":[{"count":3,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1097\/revisions"}],"predecessor-version":[{"id":1101,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1097\/revisions\/1101"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1100"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=1097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=1097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=1097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}