{"id":4890,"date":"2018-09-20T13:15:50","date_gmt":"2018-09-20T13:15:50","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4890"},"modified":"2018-09-27T18:58:55","modified_gmt":"2018-09-27T18:58:55","slug":"ssis-delete-amazon-s3-file-folder-bucket","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/","title":{"rendered":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full alignleft\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-s3-task\/ssis-amazon-s3-cloud-task.png\" width=\"128\" height=\"128\" \/>In our <a href=\"https:\/\/zappysys.com\/blog\/category\/ssis\/tasks\/ssis-amazon-storage-task\/\" target=\"_blank\" rel=\"noopener\">previous posts<\/a> we looked at how to use <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon Storage Task (Amazon S3 Task)<\/a>\u00a0to automate some Amazon S3 related tasks in SSIS.\u00a0In this blog post will continue discovering more use cases. Let&#8217;s learn how to delete Amazon S3 File, delete Amazon S3 Folder and delete Amazon S3 Bucket.<\/p>\n<p>Deleting S3 Files are straight forward using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon Storage Task (Amazon S3 Task<\/a>\u00a0but deleting Bucket or Folders require some additional checks and steps, so let&#8217;s look at that in depth.<\/p>\n<h2><\/h2>\n<h2><\/h2>\n<h2>Requirements<\/h2>\n<p>Before we look into Step-By-Step section to call Amazon S3 related operations in SSIS let\u2019s make sure you met the\u00a0following requirements.<\/p>\n<ol>\n<li>SSIS designer installed.\u00a0Sometimes it is referred as BIDS or SSDT (<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt\" target=\"_blank\" rel=\"noopener\">download it from Microsoft site<\/a>).<\/li>\n<li>Basic knowledge of SSIS package\u00a0development using\u00a0<em>Microsoft SQL Server Integration Services<\/em>.<\/li>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack\u00a0installed<\/a>. Click on the link to download a FREE trial.<\/li>\n<li>You have obtained Amazon S3 account access key \/ secret key.<\/li>\n<\/ol>\n<h2>Configure SSIS Amazon S3 Connection<\/h2>\n<p>Before we perform any S3 related action, you must configure <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/amazon-storage-connection-manager.htm\" target=\"_blank\" rel=\"noopener\">Amazon Storage Connection<\/a>. This connection manager support connectivity to not only S3 Storage but also other AWS Storage such as <a href=\"https:\/\/zappysys.com\/blog\/tag\/dynamodb\/\" target=\"_blank\" rel=\"noopener\">DynamoDB<\/a>, <a href=\"https:\/\/zappysys.com\/blog\/tag\/redshift\/\" target=\"_blank\" rel=\"noopener\">Redshift<\/a><\/p>\n<p>There are two ways you can create Amazon Storage Connection Manager in SSIS designer. You can right click in Connection Manager Panel and create new <strong>ZS-AMAZON-STORAGE<\/strong> connection type or use Task UI and click New connection.<\/p>\n<p>For now, we will use easier method which is Create S3 Connection from S3 Storage Task UI.<\/p>\n<ol>\n<li>Open SSIS Package<\/li>\n<li>Drag ZS Amazon S3 Storage Task from the toolbox<\/li>\n<li>Double click it to edit. You can now click on New Connection like below.\n<div style=\"width: 539px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-s3-task\/configure-ssis-amazon-s3-storage-task-2.png\" alt=\"Create New Amazon S3 Connection from Task UI\" width=\"529\" height=\"255\" \/><p class=\"wp-caption-text\">Create New Amazon S3 Connection from Task UI<\/p><\/div><\/li>\n<li>On the connection Manager UI. Select S3 as service type. Enter your Access Key, Secret Key and Select Region. We also support IAM Role for EC2 instances (For this package must run inside EC2 VM). <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/360009749954-How-to-use-IAM-role-for-Amazon-S3-related-operations-in-SSIS\" target=\"_blank\" rel=\"noopener\">Check this article<\/a>.\n<div style=\"width: 590px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-s3-task\/configure-ssis-amazon-s3-storage-task-3.png\" alt=\"Configure SSIS Amazon S3 Connection - Select Region, Enter Access Key \/ Secret Key\" width=\"580\" height=\"508\" \/><p class=\"wp-caption-text\">Configure SSIS Amazon S3 Connection &#8211; Select Region, Enter Access Key \/ Secret Key<\/p><\/div><\/li>\n<li>Click Test connection to confirm its working. Click OK to Save Connection Manager UI.<\/li>\n<li>Back to Task UI click OK to close save (We will configure task in later sections.<\/li>\n<\/ol>\n<h2>Using SSIS Amazon S3 Task for common actions<\/h2>\n<p>Before we deep dive in delete scenarios let&#8217;s first look at what is\u00a0 <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon Storage Task (Amazon S3 Task)<\/a>. This task is developed to achieve many S3 related operations. See below screenshot to get idea about many actions you can perform using just one task. In this post we will focus only on delete actions (for file, folder and bucket). In other posts we will cover different operations in depth.<\/p>\n<div style=\"width: 610px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-s3-task\/ssis-amazon-s3-storage task-operations-upload-download-delete-list-get-create-file-bucket.png\" alt=\"SSIS Amazon S3 Task Operations - Upload, Download, Delete, Create, List, Rename Files, Folders, Buckets\" width=\"600\" height=\"587\" \/><p class=\"wp-caption-text\">SSIS Amazon S3 Task Operations &#8211; Upload, Download, Delete, Create, List, Rename Files, Folders, Buckets<\/p><\/div>\n<h2>Delete Amazon S3 Files<\/h2>\n<p>Once you have configured SSIS S3 Connection Manager, we can perform different S3 related operations using many different Amazon S3 related tasks \/ components. For now let&#8217;s just look at how to delete files from S3 bucket.<\/p>\n<h3>Delete Multiple S3 files &#8211;\u00a0Using Simple Pattern Search (wildcard)<\/h3>\n<p>Here is how to delete amazon s3 file \/ files using wildcard pattern search. Using * or ? allowed. (Example\u00a0 SalesOrder_*.??? )<\/p>\n<div id=\"attachment_4904\" style=\"width: 612px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4904\" class=\"size-full wp-image-4904\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\" alt=\"Delete Amazon S3 File (Multiple) using Wildcard pattern\" width=\"602\" height=\"360\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png 602w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple-300x179.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><p id=\"caption-attachment-4904\" class=\"wp-caption-text\">Delete Amazon S3 File (Multiple) using Wildcard pattern<\/p><\/div>\n<h3>Delete Multiple S3 files &#8211;\u00a0Using Advanced Search &#8211; Regex \/ SQL Expression<\/h3>\n<p>Sometimes it&#8217;s necessary to filter file based on advanced attributes such as file Age (How old), File Size, Multiple File Patterns (e.g. Delete *.zip, *.gz, *.rar in one action)<\/p>\n<p>You can use Advanced Tab to filter further. First supply primary filter on Source Tab (e.g. mybucket\/*.* ) and then supply your advanced filter (e.g. you can exclude *.exe and *.msi file from your delete list as below screenshot, also only delete files between 1000 and 50000 bytes in file size).<\/p>\n<div style=\"width: 686px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-s3-task\/amazon-s3-file-file-advanced-search-regx-pattern.png\" alt=\"Advanced Search in SSIS Amazon S3 Task - Use Regular Expression Patterns, SQL like expression for Sort \/ Filter\" width=\"676\" height=\"540\" \/><p class=\"wp-caption-text\">Advanced Search in SSIS Amazon S3 Task &#8211; Use Regular Expression Patterns, SQL like expression for Sort \/ Filter<\/p><\/div>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\nExamples:\r\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\nAgeInDays &lt; 5  \/\/Get files created in last 5 days\r\nLastEditInDays &gt; 3 \/\/Get files modified before 3 days\r\nAgeInDays &gt; 10 AND LastEditInDays &lt; 3  \/\/Get files created before 10 days and modified in last 3 days\r\nSize &lt; 1024  \/\/Get files where File size is less than 1024 bytes\r\nCreationDate BETWEEN #2015-01-01# AND #2015-01-01#   \r\nName IN ('File1.txt', 'Download.msi')\r\nFullPath LIKE 'mybucket\\somefolder\\month_*')\r\nExtension IN ('.txt','.csv')\r\nLastModifiedDate &gt; #2013-01-01T16:00:00#\r\nIsReadOnly = True\r\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n\/\/Supported Columns for expression:\r\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\nName, FullPath, Extension, FolderPath, AgeInDays, LastEditInDays, Size, CreationDate, CreationDateUtc, LastModifiedDate, LastModifiedDateUtc, IsReadOnly<\/pre>\n<h2><\/h2>\n<h3>Delete Amazon S3 files older than X days<\/h3>\n<p>If you like to delete files older than certain days then use below technique.<\/p>\n<ol>\n<li>First Specify primary search criteria on Source tab<\/li>\n<li>Go to Advanced Filter Tab and specify Following Pattern in <strong>Where<\/strong> Textbox (For example delete Files older than 10 days )\n<pre class=\"lang:default decode:true \">AgeInDays &gt; 10<\/pre>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>Delete Amazon S3 Bucket<\/h2>\n<p>Now let&#8217;s look at how to delete Amazon S3 Bucket including all its content. There is an option to delete Bucket but it wont delete files and empty folders. So you have to first clear all its content before calling Delete bucket action.<\/p>\n<p>Here is high level steps to delete bucket in SSIS using ZappySys S3 Task.<\/p>\n<ol>\n<li>First call Delete S3 Files Action using Source Path = <strong>mybucket\/*.<\/strong>\u00a0Delete file action won&#8217;t delete any real folders (i.e. name ends with slash).<\/li>\n<li>Once files are deleted from bucket you can get list of empty folders\n<ol>\n<li>Select Action = Get Amazon folder list as ADO.net Table<\/li>\n<li>In the path enter Path =\u00a0<strong>mybucket\/*<\/strong><\/li>\n<li>In the Result Variable Create or Select variable (e.g. User::FolderList)<\/li>\n<\/ol>\n<\/li>\n<li>Use ForEachLoop Task to Delete empty folders (Use <strong>Delete File Action<\/strong>\u00a0because there is no folder concept in S3. File name ends with slash is treated as folder)\n<ol>\n<li>In the ForEachLoop Task select enumerator as\u00a0 <strong>Foreach ADO\u00a0enumerator<\/strong><\/li>\n<li>In the variable select a variable which holds list of folders (obtained in previous step)<\/li>\n<li>On the Variable Mappings Tab. Select Some variable (e.g. User::FolderPath) to map to Index =0<\/li>\n<li>Drag new S3 Task inside ForEachLoop and Select\u00a0<strong>Delete File Action<\/strong><\/li>\n<li>In the File Path enter variable as\u00a0{{User::FolderPath}}\u00a0 (or whatever name you given which holds iteration FolderPath in previous step)<\/li>\n<\/ol>\n<\/li>\n<li>Call Delete Bucket Action once bucket is totally empty.<\/li>\n<\/ol>\n<div id=\"attachment_4905\" style=\"width: 315px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazon-s3-bucket-including-files-folders.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4905\" class=\"size-full wp-image-4905\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazon-s3-bucket-including-files-folders.png\" alt=\"Delete Amazon S3 Bucket (including files and folders)\" width=\"305\" height=\"549\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazon-s3-bucket-including-files-folders.png 305w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazon-s3-bucket-including-files-folders-167x300.png 167w\" sizes=\"(max-width: 305px) 100vw, 305px\" \/><\/a><p id=\"caption-attachment-4905\" class=\"wp-caption-text\">Delete Amazon S3 Bucket (including files and folders)<\/p><\/div>\n<h2>Delete Amazon S3 Folders<\/h2>\n<p>There is no real folder concept in Amazon S3 file system. S3 File System is just key \/ value system. Key is basically file name (e.g. somefolder\/subfolder\/myfile.txt). You can use slash in name to indicate hierarchy which can be used by some client apps like ZappySys S3 File Picker to Mimic Treeview like structure so user feel like real file system but there are no rules if you have to use slash or not.<\/p>\n<p>Most client tools for S3 treats any file name ends with slash as real folder.\u00a0 See below step to delete amazon s3 folder (real folder which was created explicitly &#8211; mentioned in next section).<\/p>\n<ol>\n<li>Open S3 Task and select action = Delete Amazon File(s)<\/li>\n<li>In the path enter your Folder Path (e.g.\u00a0mybucketname\/output\/sub2\/ )<\/li>\n<\/ol>\n<h2>Create Amazon S3 Folder<\/h2>\n<p>Some time you may want to create real S3 folder which is not treated as file. In that case <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/360009493993-How-to-create-folder-in-Amazon-S3-Bucket-using-SSIS\" target=\"_blank\" rel=\"noopener\">use this technique<\/a> to create s3 folder.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/zappysys.zendesk.com\/hc\/article_attachments\/360013007793\/ssis-amazon-s3-create-new-folder-in-bucket.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Conclusion<\/h2>\n<p>In this post we saw how easy it is to use <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-s3-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon Storage Task (Amazon S3 Task)<\/a>\u00a0to delete Amazon S3 file, folder and bucket. You can also perform other common amazon storage related actions (e.g. Upload \/ Download \/ Create \/ List ). <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">Download SSIS PowerPack<\/a> to try this component and <strong>70+ other tasks \/ components<\/strong> which are not covered in this article.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous posts we looked at how to use SSIS Amazon Storage Task (Amazon S3 Task)\u00a0to automate some Amazon S3 related tasks in SSIS.\u00a0In this blog post will continue discovering more use cases. Let&#8217;s learn how to delete Amazon S3 File, delete Amazon S3 Folder and delete Amazon S3 Bucket. Deleting S3 Files [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4904,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[181],"tags":[29,35,12],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog\" \/>\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-delete-amazon-s3-file-folder-bucket\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/\" \/>\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=\"2018-09-20T13:15:50+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-09-27T18:58:55+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"602\" \/>\r\n\t<meta property=\"og:image:height\" content=\"360\" \/>\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-delete-amazon-s3-file-folder-bucket\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/\",\"name\":\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\",\"datePublished\":\"2018-09-20T13:15:50+00:00\",\"dateModified\":\"2018-09-27T18:58:55+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png\",\"width\":602,\"height\":360,\"caption\":\"Delete Amazon S3 File (Multiple) using Wildcard pattern\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS\"}]},{\"@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":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog","description":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog","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-delete-amazon-s3-file-folder-bucket\/","og_locale":"en_US","og_type":"article","og_title":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog","og_description":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-09-20T13:15:50+00:00","article_modified_time":"2018-09-27T18:58:55+00:00","og_image":[{"width":602,"height":360,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.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-delete-amazon-s3-file-folder-bucket\/","url":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/","name":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png","datePublished":"2018-09-20T13:15:50+00:00","dateModified":"2018-09-27T18:58:55+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/ssis-delete-amazons3-file-multiple.png","width":602,"height":360,"caption":"Delete Amazon S3 File (Multiple) using Wildcard pattern"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-delete-amazon-s3-file-folder-bucket\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to delete Amazon S3 File \/ Folder \/ Bucket in SSIS"}]},{"@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\/4890"}],"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=4890"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4890\/revisions"}],"predecessor-version":[{"id":4954,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4890\/revisions\/4954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/4904"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}