{"id":35787,"date":"2024-11-19T09:46:14","date_gmt":"2024-11-19T08:46:14","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=35787"},"modified":"2024-11-19T09:46:16","modified_gmt":"2024-11-19T08:46:16","slug":"export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/","title":{"rendered":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Introduction<\/h1>\n\n\n\n<p>Hello, Readers!<\/p>\n\n\n\n<p>While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the \u201c<strong>Unable to create Azure container<\/strong>\u201d error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Context<\/h1>\n\n\n\n<p>The logic of the example is quite simple and consists of two main steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Extract data from a local database<\/li>\n\n\n\n<li>Export the extracted data as a text file to Azure Blob Storage<\/li>\n<\/ul>\n\n\n\n<p>The prerequisites for this process include:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Azure Storage<\/h3>\n\n\n\n<p>For this example, an <strong>Azure Storage Account<\/strong> and a <strong>Blob Storage Container<\/strong> were created to store the exported data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Local Database<\/h3>\n\n\n\n<p>The data source for this export is the <strong>Product<\/strong> table in the <strong>SalesLT<\/strong> schema of the <strong>AdventureWorksLT2022<\/strong> database, a sample provided by Microsoft. You can access it <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/samples\/adventureworks-install-configure?view=sql-server-ver16&amp;tabs=ssms\">here<\/a>.<\/p>\n\n\n\n<p>The structure of table Product is described in the following picture:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"527\" height=\"630\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\" alt=\"\" class=\"wp-image-35790\" style=\"width:299px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png 527w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16-251x300.png 251w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDE<\/h3>\n\n\n\n<p>The development environment is <strong>Visual Studio 2022<\/strong>, with the <strong>SQL Server Integration Services Projects 2022<\/strong> extension installed.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Problem Statement<\/h1>\n\n\n\n<p>The goal is to export the following fields from the Product table to a CSV file in Azure Blob Storage: <em>ProductNumber<\/em>, <em>Name<\/em>, <em>Color<\/em>, <em>StandardCost<\/em>, <em>ListPrice<\/em>, <em>Size<\/em>, <em>Weight<\/em>, and <em>SellStartDate<\/em>. Here\u2019s a breakdown of the steps I followed:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data Flow Creation<\/h3>\n\n\n\n<p>I created a Data Flow task with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>OLE DB Source<\/strong> for reading data from SQL Server.<\/li>\n\n\n\n<li><strong>Azure Blob Destination<\/strong> for exporting the data to Azure Blob Storage.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OLE DB Source Settings<\/h3>\n\n\n\n<p>To simplify the process:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A SQL query was used in the SSIS SQL Command Text instead of a stored procedure (as recommended by best practices), avoiding any updates to the AdventureWorksLT2022 database.<\/li>\n\n\n\n<li>The <strong>SellStartDate<\/strong> formatting was handled within the SQL query, eliminating the need for a Derived Column transformation.<\/li>\n<\/ul>\n\n\n\n<p><strong>Connection Manager settings<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"695\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-17.png\" alt=\"\" class=\"wp-image-35792\" style=\"width:404px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-17.png 691w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-17-298x300.png 298w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-17-150x150.png 150w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p><strong>OLE DB Source settings<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"717\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-18.png\" alt=\"\" class=\"wp-image-35793\" style=\"width:426px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-18.png 726w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-18-300x296.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Azure Blob Destination Settings<\/h3>\n\n\n\n<p>The <strong>Azure Storage Connection Manager<\/strong> was configured with the necessary access credentials, enabling data export to Azure Blob Storage.<\/p>\n\n\n\n<p><strong>Azure Storage Connection Manager settings<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"716\" height=\"772\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-19.png\" alt=\"\" class=\"wp-image-35794\" style=\"width:339px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-19.png 716w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-19-278x300.png 278w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/figure>\n\n\n\n<p>(Azure storage details are retrieve from Azure as shown below)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"376\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-20.png\" alt=\"\" class=\"wp-image-35795\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-20.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-20-300x120.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-20-768x307.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p><strong>Azure Blob Storage Destination settings<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"678\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-21.png\" alt=\"\" class=\"wp-image-35796\" style=\"width:408px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-21.png 714w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-21-300x285.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"678\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-22.png\" alt=\"\" class=\"wp-image-35797\" style=\"width:406px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-22.png 714w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-22-300x285.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3.4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Complete flow<\/h3>\n\n\n\n<p>After setting up both components, the Data Flow was ready for execution, as shown in the final configuration image.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"329\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-23.png\" alt=\"\" class=\"wp-image-35799\" style=\"width:375px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-23.png 498w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-23-300x198.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3.5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Execution<\/h3>\n\n\n\n<p>Upon execution, the package fails with the error: &#8220;<strong>Unable to create Azure Blob container<\/strong>&#8220;<\/p>\n\n\n\n<p>Error details are shown in the following pictures:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"598\" height=\"335\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-24.png\" alt=\"\" class=\"wp-image-35800\" style=\"width:452px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-24.png 598w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-24-300x168.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1393\" height=\"504\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1.png\" alt=\"\" class=\"wp-image-35805\" style=\"width:918px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1.png 1393w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1-300x109.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1-1024x370.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1-768x278.png 768w\" sizes=\"auto, (max-width: 1393px) 100vw, 1393px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"2774\" height=\"1436\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1.png\" alt=\"\" class=\"wp-image-35804\" style=\"width:792px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1.png 2774w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-300x155.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1024x530.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-768x398.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-1536x795.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/Picture1-2048x1060.png 2048w\" sizes=\"auto, (max-width: 2774px) 100vw, 2774px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Root Cause Analysis<\/h1>\n\n\n\n<p>This error is often due to an issue with <strong>Transport Layer Security (TLS)<\/strong>. Azure Blob Storage requires connections to use <strong>TLS version 1.2<\/strong>. However, the default configuration for the Azure Feature Pack in SSIS may not enforce TLS 1.2, as it depends on the .NET Framework settings on the system.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Solution<\/h1>\n\n\n\n<p>To resolve this, the system\u2019s .NET Framework settings must be modified to enforce TLS 1.2. This can be done by adding a <strong>REG_DWORD<\/strong> value named <strong>SchUseStrongCrypto<\/strong> with a value of <strong>1<\/strong> under the following registry keys:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"87\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-27.png\" alt=\"\" class=\"wp-image-35807\" style=\"width:691px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-27.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-27-300x28.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-27-768x71.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>Registry key creation<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"185\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-28.png\" alt=\"\" class=\"wp-image-35808\" style=\"width:305px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-28.png 366w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-28-300x152.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"350\" height=\"217\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-29.png\" alt=\"\" class=\"wp-image-35809\" style=\"width:253px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-29.png 350w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-29-300x186.png 300w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/figure>\n\n\n\n<p>Final values after key creation<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"98\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-30.png\" alt=\"\" class=\"wp-image-35810\" style=\"width:396px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-30.png 491w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-30-300x60.png 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure>\n\n\n\n<p>This registry update forces .NET to use TLS 1.2 for secure connections, satisfying Azure\u2019s requirement.<\/p>\n\n\n\n<p>After applying this update, I reran the SSIS package, which completed successfully.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"301\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-31.png\" alt=\"\" class=\"wp-image-35811\" style=\"width:419px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-31.png 601w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-31-300x150.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/figure>\n\n\n\n<p>The <strong>Products.csv<\/strong> file was created and uploaded to the Azure Blob Container as expected.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"272\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-32.png\" alt=\"\" class=\"wp-image-35812\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-32.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-32-300x87.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-32-768x222.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>The content of file Products.csv is shown in the below picture<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"406\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-33.png\" alt=\"\" class=\"wp-image-35813\" style=\"width:626px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-33.png 809w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-33-300x151.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-33-768x385.png 768w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Conclusion<\/h1>\n\n\n\n<p>For seamless SSIS integration with Azure Blob Storage, ensure that your system enforces TLS 1.2 by updating the .NET Framework registry settings. This resolves the \u201cUnable to create Azure Blob container\u201d error, facilitating successful data export to Azure Blob Storage.<\/p>\n\n\n\n<p>Stay tuned for further insights in upcoming posts!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the \u201cUnable to create Azure container\u201d error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future. 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Context The logic of the example is [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294],"tags":[3465,3462,3466,3464,592,3463,3467],"type_dbi":[],"class_list":["post-35787","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","tag-net-framework-settings","tag-azure-blob-storage","tag-azure-feature-pack","tag-azure-storage-error","tag-ssis","tag-tls-1-2","tag-unable-to-create-blob-container"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error\" \/>\n<meta property=\"og:description\" content=\"1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the \u201cUnable to create Azure container\u201d error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future. 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Context The logic of the example is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-19T08:46:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-19T08:46:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\" \/>\n\t<meta property=\"og:image:width\" content=\"527\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error\",\"datePublished\":\"2024-11-19T08:46:14+00:00\",\"dateModified\":\"2024-11-19T08:46:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\"},\"wordCount\":676,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\",\"keywords\":[\".NET Framework Settings\",\"Azure Blob Storage\",\"Azure Feature Pack\",\"Azure Storage Error\",\"SSIS\",\"TLS 1.2\",\"Unable to Create Blob Container\"],\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\",\"name\":\"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\",\"datePublished\":\"2024-11-19T08:46:14+00:00\",\"dateModified\":\"2024-11-19T08:46:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png\",\"width\":527,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error - dbi 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:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/","og_locale":"en_US","og_type":"article","og_title":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error","og_description":"1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the \u201cUnable to create Azure container\u201d error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future. 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Context The logic of the example is [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/","og_site_name":"dbi Blog","article_published_time":"2024-11-19T08:46:14+00:00","article_modified_time":"2024-11-19T08:46:16+00:00","og_image":[{"width":527,"height":630,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error","datePublished":"2024-11-19T08:46:14+00:00","dateModified":"2024-11-19T08:46:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/"},"wordCount":676,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png","keywords":[".NET Framework Settings","Azure Blob Storage","Azure Feature Pack","Azure Storage Error","SSIS","TLS 1.2","Unable to Create Blob Container"],"articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/","url":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/","name":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png","datePublished":"2024-11-19T08:46:14+00:00","dateModified":"2024-11-19T08:46:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/11\/image-16.png","width":527,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/export-data-to-azure-storage-with-ssis-solving-the-unable-to-create-azure-blob-container-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Export Data to Azure Storage with SSIS: Solving the \u2018Unable to Create Azure Blob Container\u2019 Error"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=35787"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35787\/revisions"}],"predecessor-version":[{"id":35814,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35787\/revisions\/35814"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=35787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=35787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=35787"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=35787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}