{"id":19861,"date":"2023-04-24T06:44:00","date_gmt":"2023-04-24T04:44:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=19861"},"modified":"2023-05-15T11:55:17","modified_gmt":"2023-05-15T09:55:17","slug":"import-excel-cells-with-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/","title":{"rendered":"Import Excel cells with SSIS into SQL Server and filter the data"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\" id=\"h-how-to-import-and-filtrer-a-range-of-specific-excel-cells-into-a-sql-server-table-with-ssis\"><strong><em>How to import and filtrer a range of specific Excel cells into a SQL Server table with SSIS?<\/em><\/strong><\/h4>\n\n\n\n<p>When importing data from an XLSX file into a SQL table, it is possible to import specific Excel cells with the SSIS options. The range will necessarily be contiguous, in other words, the Excel cells to be loaded are side by side. However, to load multiple non-contiguous ranges of cells, the method presented in this tutorial must be adapted.<\/p>\n\n\n\n<p>To load an Excel range where the cells are separated or only certain targeted Excel cells. It is necessary to go through a specific SSIS data flow development to process each range separately. It is necessary to run several data flows or a loop with dynamic queries.<\/p>\n\n\n\n<p>To load a particular range of Excel cells, it is necessary to write a static query. This query specifies which cells are to be loaded. Excel <a href=\"https:\/\/www.myaccountingcourse.com\/accounting-dictionary\/spreadsheet\" target=\"_blank\" rel=\"noreferrer noopener\">spreadsheets<\/a> are extraordinarily powerful and are very often integrated into databases for data warehouse projects.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#1-download-the-excel-file-used-in-the-tutorial\" >1. Download the Excel file used in the tutorial<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#2-sql-query-to-load-an-excel-range-with-ssis\" >2. SQL query to load an Excel range with SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#3-ssis-query-to-filter-out-empty-excel-rows\" >3. SSIS query to filter out empty Excel rows<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#4-filter-excel-data-without-column-names\" >4. Filter Excel data without column names<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#5-query-to-select-excel-rows-dynamically\" >5. Query to select Excel rows dynamically<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#6-create-the-complete-ssis-package-in-4-steps\" >6. Create the complete SSIS package in 4 steps<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-download-the-excel-file-used-in-the-tutorial\"><\/span>1. Download the Excel file used in the tutorial<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a sample of the data range used in the Excel file, it contains 24 rows of data, and after each block of 5 rows, there is a blank row, to test the behaviour of the filters from SSIS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"523\" height=\"739\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1bis-data-range-overview-1.jpg\" alt=\"Excel data range from the Excel file used in the tutorial\" class=\"wp-image-12411\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1bis-data-range-overview-1.jpg 523w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1bis-data-range-overview-1-212x300.jpg 212w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><figcaption class=\"wp-element-caption\">Excel data range from the Excel file used in the tutorial<\/figcaption><\/figure><\/div>\n\n\n<p>Here is the link to download the source Excel file.<\/p>\n\n\n\n<div class=\"wp-block-file aligncenter\"><a id=\"wp-block-file--media-79eb05a9-c2b9-45a7-b24d-97284a97c3d7\" href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data_Sample.xlsx\"><strong>Customers_Data_Sample.xlsx<\/strong><\/a><a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data_Sample.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-79eb05a9-c2b9-45a7-b24d-97284a97c3d7\"><strong>Download<\/strong><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-sql-query-to-load-an-excel-range-with-ssis\"><\/span>2. SQL query to load an Excel range with SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this first example of a SQL query, the query retrieves all the cells of an Excel table. That is, from the 3rd to the 13th row, and from column A to column C of the MS Excel file to be loaded with the package.<\/p>\n\n\n\n<p>Storing or not storing the source data in an Excel table does not change the SQL query behaviour. In other words, this query loads the Excel cells without filtering the data upstream.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [Sheet1$A3:C13];<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"568\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1-simple-range.jpg\" alt=\"Import Excel cells with SSIS using a SQL query in the Excel component\" class=\"wp-image-12371\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1-simple-range.jpg 594w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-1-simple-range-300x287.jpg 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><figcaption class=\"wp-element-caption\">Import Excel cells with SSIS using a SQL query in the Excel component<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-ssis-query-to-filter-out-empty-excel-rows\"><\/span>3. SSIS query to filter out empty Excel rows<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this second example, the SQL query is used to filter the data. And therefore to select all rows with the first cell of the selected range not null. And from the 3rd to the 10th row, from column A to column D, of the Microsoft Excel file.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [Sheet1$A3:C13]\nWHERE CustomerID IS NOT NULL;<\/pre>\n\n\n\n<p>Use the <strong><em>HDR=YES<\/em><\/strong> parameter to indicate that the column names are fixed and used in the query for example.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\data\\Customers_Data_Sample.xlsx;Extended Properties=\"EXCEL 12.0 XML;HDR=YES\";<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"564\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-2-filter-column-name.jpg\" alt=\"SQL Query with a filter on the Excel column using SSIS\" class=\"wp-image-12375\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-2-filter-column-name.jpg 595w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-2-filter-column-name-300x284.jpg 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><figcaption class=\"wp-element-caption\"><strong>SQL Query with a filter on the Excel column using SSIS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"htSYFt9tjY\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/ssis-connection-string-to-load-excel-files\/\">SSIS connection string to load Excel files<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;SSIS connection string to load Excel files&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/ssis-connection-string-to-load-excel-files\/embed\/#?secret=vzu7K8q2Fo#?secret=htSYFt9tjY\" data-secret=\"htSYFt9tjY\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-filter-excel-data-without-column-names\"><\/span>4. Filter Excel data without column names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To use generic column names such as F1, F2, F3, etc. Use syntax like this to construct the Excel connection string. This option is particularly useful for loading data with column names that may change.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [Sheet1$A3:C13]\nWHERE F1 IS NOT NULL;<\/pre>\n\n\n\n<p>So use the HDR=NO option to not enable column name handling. <strong><em>HDR <\/em><\/strong>is simply an abbreviation for <strong><em>Header<\/em><\/strong>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Data Source=C:\\dossier\\file.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=\"Excel 12.0 Xml;HDR=NO\";<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"573\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-3-filter-generic-column.jpg\" alt=\"SQL query on Excel File from SSIS with a filter on generic column name\" class=\"wp-image-12380\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-3-filter-generic-column.jpg 599w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-3-filter-generic-column-300x287.jpg 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><figcaption class=\"wp-element-caption\">SQL query on Excel File from SSIS with a filter on generic column name<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-query-to-select-excel-rows-dynamically\"><\/span>5. Query to select Excel rows dynamically<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this last example of a query, here is how to load Excel cells with SSIS and select the data up to the last row of the table without knowing the number of rows. To do this use this variant of the query, where you only need to fill in the name of the rightmost column of the range to be loaded without the row number. The empty rows are loaded, to filter them, add the WHERE clause again as in the previous examples.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [Sheet1$A3:E];<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"564\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-4-full-data-range.jpg\" alt=\"SQL query to load an Excel range and select all rows having data \" class=\"wp-image-12384\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-4-full-data-range.jpg 595w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-sql-query-load-excel-4-full-data-range-300x284.jpg 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><figcaption class=\"wp-element-caption\">SQL query to load an Excel range and select all rows having data <\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-create-the-complete-ssis-package-in-4-steps\"><\/span>6. Create the complete SSIS package in 4 steps<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To finally put these queries into practice, import Excel files into SQL Server and perform other transformation tasks. Such as filtering and sorting the data before loading it into the database. Also use SSIS to import Excel data in both directions, i.e. <a href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\">import data from Excel to SQL Server<\/a> or export data from MS SQL to an Excel file.<\/p>\n\n\n\n<p>The creation of the package is done in 4 steps, in an <a href=\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\">Integration Services data flow<\/a>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>First create a connection with the SSIS manager to point to the source file.<\/li>\n\n\n\n<li>Add an Excel Source that uses the connection and use the query to filter the cells.<\/li>\n\n\n\n<li>Create an OLE DB destination to the target database and table and configure it.<\/li>\n\n\n\n<li>Then configure the data mapping.<\/li>\n<\/ol>\n\n\n\n<p>For details of the steps, here is how to load an Excel file into a SQL Server table. This SSIS tutorial explains step by step how to load cells from an Excel sheet into a table. It is also possible to <a href=\"https:\/\/expert-only.com\/en\/ssms\/import-excel-to-sql-server-with-ssms\/\">load an Excel file into a table with the SQL Server Wizard<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"66ABIiZHz5\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\">Import an Excel file into a SQL table with SSIS<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Import an Excel file into a SQL table with SSIS&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/embed\/#?secret=t1akPia67W#?secret=66ABIiZHz5\" data-secret=\"66ABIiZHz5\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to import and filtrer a range of specific Excel cells into a SQL Server table with SSIS? When importing data from an XLSX file into a SQL table, it is possible to import specific Excel cells with the <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\" title=\"Import Excel cells with SSIS into SQL Server and filter the data\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10459,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[],"class_list":{"0":"post-19861","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import Excel cells with SSIS into SQL Server and filter the data<\/title>\n<meta name=\"description\" content=\"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Excel cells with SSIS into SQL Server and filter the data\" \/>\n<meta property=\"og:description\" content=\"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-24T04:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-15T09:55:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Import Excel cells with SSIS into SQL Server and filter the data\",\"datePublished\":\"2023-04-24T04:44:00+00:00\",\"dateModified\":\"2023-05-15T09:55:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\"},\"wordCount\":808,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\",\"name\":\"Import Excel cells with SSIS into SQL Server and filter the data\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg\",\"datePublished\":\"2023-04-24T04:44:00+00:00\",\"dateModified\":\"2023-05-15T09:55:17+00:00\",\"description\":\"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import Excel cells with SSIS into SQL Server and filter the data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Import Excel cells with SSIS into SQL Server and filter the data","description":"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.","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:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Import Excel cells with SSIS into SQL Server and filter the data","og_description":"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.","og_url":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-04-24T04:44:00+00:00","article_modified_time":"2023-05-15T09:55:17+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Import Excel cells with SSIS into SQL Server and filter the data","datePublished":"2023-04-24T04:44:00+00:00","dateModified":"2023-05-15T09:55:17+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/"},"wordCount":808,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/","url":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/","name":"Import Excel cells with SSIS into SQL Server and filter the data","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg","datePublished":"2023-04-24T04:44:00+00:00","dateModified":"2023-05-15T09:55:17+00:00","description":"Import specific Excel cells into a SQL Server table with SSIS using the Excel component to select and filter data with SQL queries.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/city-C1FDB1FE43F_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-cells-with-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Import Excel cells with SSIS into SQL Server and filter the data"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/19861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=19861"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/19861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10459"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=19861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=19861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=19861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}