{"id":13204,"date":"2022-09-06T07:06:00","date_gmt":"2022-09-06T05:06:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=13204"},"modified":"2023-05-16T18:41:34","modified_gmt":"2023-05-16T16:41:34","slug":"import-excel-file-into-sql-table-with-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/","title":{"rendered":"Import an Excel file into a SQL table with SSIS"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\" id=\"h-import-an-excel-file-into-a-sql-server-table-with-an-ssis-package\"><strong><em>Import an Excel file into a SQL Server table with an SSIS package.<\/em><\/strong><\/h4>\n\n\n\n<p>Step by step tutorial to import data from an Excel file (xslx) into a SQL Server table with an SSIS package. Here, the target is a SQL Server database. From Visual Studio, use the native Excel component available in the SSIS data stream source connections.<\/p>\n\n\n\n<p>To load one or more Excel files into a <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server<\/a> database with Visual Studio, first create an SSIS package. First, open <a href=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/\">Visual Studio and create a new SSIS project<\/a> and a new package as explained in the dedicated tutorial.<\/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-file-into-sql-table-with-ssis\/#1-prepare-the-target-table-and-the-excel-source-file-to-import\" >1. Prepare the target table and the Excel source file to import<\/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-file-into-sql-table-with-ssis\/#2-create-an-ssis-data-flow-from-the-excel-to-sql-server\" >2. Create an SSIS data flow from the Excel to SQL Server<\/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-file-into-sql-table-with-ssis\/#3-create-a-new-connection-manager-to-connect-to-the-excel-file\" >3. Create a new connection manager to connect to the Excel file<\/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-file-into-sql-table-with-ssis\/#4-configure-the-excel-source-component\" >4. Configure the Excel source component<\/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-file-into-sql-table-with-ssis\/#5-change-column-types-at-the-output-of-the-excel-source-component\" >5. Change column types at the output of the Excel Source component<\/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-file-into-sql-table-with-ssis\/#6-configure-the-sql-server-target-table-to-import-the-excel-file\" >6. Configure the SQL Server target table to import the Excel file<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#7-run-the-ssis-package-and-import-excel-data-into-sql-server\" >7. Run the SSIS package and import Excel data into SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#8-check-the-result-using-ssms-and-a-sql-query\" >8. Check the result using SSMS and a SQL query<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-prepare-the-target-table-and-the-excel-source-file-to-import\"><\/span>1. Prepare the target table and the Excel source file to import<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The destination table is the customer table with a basic structure, here is the code to create it.<\/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=\"\">-- Create the customer table\nCREATE TABLE [dbo].[Customers](\n   [CustomerID] [int] NOT NULL,\n   [FirstName] [nvarchar](20) NULL,\n   [LastName] [nvarchar](20) NULL,\n   [City] [nvarchar](20) NULL,\n   [Country] [nvarchar](50) NULL,\n   CONSTRAINT [CustomersPrimaryKeyCustomerID] PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO<\/pre>\n\n\n\n<p>This customer file, to be imported into the table in this tutorial contains 48 lines. The file has the same structure as the target table, i.e., 5 columns. Download the example file here:<\/p>\n\n\n\n<div class=\"wp-block-file aligncenter\"><a id=\"wp-block-file--media-73808cd5-67ed-4a20-84ec-42c6d8a44775\" href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data.xlsx\"><strong>Customers_Data.xlsx<\/strong><\/a><a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-73808cd5-67ed-4a20-84ec-42c6d8a44775\">Download<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-create-an-ssis-data-flow-from-the-excel-to-sql-server\"><\/span>2. Create an SSIS data flow from the Excel to SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In Visual Studio 2019, from the workspace, in the toolbox on the left. Select Data flow Task. Select Data flow Task. And drag the component onto the workspace. Double click to edit it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"685\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg\" alt=\"Create a Data Flow SSIS Task to load an Excel file\" class=\"wp-image-11381\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg 729w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow-300x282.jpg 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><figcaption class=\"wp-element-caption\">Create an SSIS Data Flow Task<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-create-a-new-connection-manager-to-connect-to-the-excel-file\"><\/span>3. Create a new connection manager to connect to the Excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create a new connection to the Excel file from the SSIS Connection Manager.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-1-new-file-connection-1.jpg\" alt=\"Select New File connection from the Connection Managers section\" class=\"wp-image-12167\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-1-new-file-connection-1.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-1-new-file-connection-1-300x253.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\"><em>Select New File connection from the Connection Managers section<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Then select the connection manager for Excel files from the list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"928\" height=\"779\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2-new-excel-connection-1.jpg\" alt=\"Select the SSIS connection manager for Excel files to import data into the SQL table\" class=\"wp-image-12171\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2-new-excel-connection-1.jpg 928w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2-new-excel-connection-1-300x252.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2-new-excel-connection-1-768x645.jpg 768w\" sizes=\"auto, (max-width: 928px) 100vw, 928px\" \/><figcaption class=\"wp-element-caption\">Select the SSIS connection manager for Excel files to import data into the table<\/figcaption><\/figure><\/div>\n\n\n<p>Now fill in the following items:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The full path of the Excel file to import into the SQL table, i.e.: <strong><em>C:\\data\\Customers_Data.xlsx<\/em><\/strong><\/li>\n\n\n\n<li>The version of Excel, choose <strong><em>Excel 2007-2010<\/em><\/strong>.<\/li>\n\n\n\n<li><strong><em>Enable the option<\/em><\/strong> for column names in the first row.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"707\" height=\"444\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2bis-set-file-path-1.jpg\" alt=\"Configure the path of the Excel file to import in the SQL Server table with SSIS\" class=\"wp-image-12175\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2bis-set-file-path-1.jpg 707w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-2bis-set-file-path-1-300x188.jpg 300w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><figcaption class=\"wp-element-caption\">Configure the path of the Excel file to import in the SQL Server table<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configure-the-excel-source-component\"><\/span>4. Configure the Excel source component<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>From the Data Flow tab, select the Excel Source component from the toolbox and drag it into the workspace.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-3-new-Excel-source-1.jpg\" alt=\"Add the Excel Source component to the SSIS Data Flow to import the data into the table\" class=\"wp-image-12163\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-3-new-Excel-source-1.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-3-new-Excel-source-1-300x253.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Add the Excel Source component to the SSIS Data Flow<\/figcaption><\/figure><\/div>\n\n\n<p>From the Excel Source component, choose the tab from the list, as below. The default tab name is displayed, i.e., <strong><em>Sheet1$<\/em><\/strong>. It is also possible to use an SQL query directly, to load a specific range of cells and not the whole table into the table. The query is of this type, and it selects all the data stored contiguously in the file. That is, a range of Excel data:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [Sheet1$A1:E]<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"813\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-4-excel-source-editor.jpg.jpg\" alt=\"Choose the tab to import into the table from the SSIS Excel Source Editor\" class=\"wp-image-12193\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-4-excel-source-editor.jpg.jpg 845w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-4-excel-source-editor.jpg-300x289.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-4-excel-source-editor.jpg-768x739.jpg 768w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><figcaption class=\"wp-element-caption\">Choose the tab to import into the table from the SSIS Excel Source Editor<\/figcaption><\/figure><\/div>\n\n\n<p>Now check the mapping to make sure that all columns are detected in the SSIS package.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"813\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-6-excel-column-mapping.jpg\" alt=\"Check the mapping of the columns in the Excel source\" class=\"wp-image-12209\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-6-excel-column-mapping.jpg 845w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-6-excel-column-mapping-300x289.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-6-excel-column-mapping-768x739.jpg 768w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><figcaption class=\"wp-element-caption\">Check the mapping of the columns in the Excel source<\/figcaption><\/figure><\/div>\n\n\n<p>Use the Preview button to preview the data and validate the content.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"674\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-5-excel-preview.jpg\" alt=\"View the content of the Excel file from the SSIS Excel Source Viewer\" class=\"wp-image-12204\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-5-excel-preview.jpg 655w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-5-excel-preview-292x300.jpg 292w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><figcaption class=\"wp-element-caption\">View the content of the Excel file from the SSIS Excel Source Viewer<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Classical Excel connection error from SSIS<\/h3>\n\n\n\n<p>On first connection to the file, if the following error is displayed:<\/p>\n\n\n\n<p><em>Could not retrieve the table information for the connection manager &#8216;Customers_Data.xlsx&#8217;.<br>Failed to connect to the source using the connection manager &#8216;Customers_Data.xlsx&#8217;<\/em><\/p>\n\n\n\n<p>Or this longer but explicit message:<\/p>\n\n\n\n<p>Exception from HRESULT: 0xC020801C<br>Error at PackageImportExcelFile [Connection manager &#8216;Customers_Data.xlsx&#8217;]: <strong>The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode.<\/strong> Error code: 0x00000000. An OLE DB record is available. Source: &#8221; Microsoft OLE DB Service Components &#8221; Hresult: 0x80040154 Description: &#8221; Class not registered &#8220;.<\/p>\n\n\n\n<p>Error at PackageImportExcelFile [Connection manager &#8220;Customers_Data.xlsx&#8221;]: The &#8216;Microsoft.ACE.OLEDB.12.0&#8217; provider is not registered on the local machine. For more information, see http:\/\/go.microsoft.com\/fwlink\/?LinkId=219816<\/p>\n\n\n\n<p>Error at Data Flow Task [Excel Source [2]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager &#8221; Customers_Data.xlsx &#8221; failed with error code 0xC0209302.<\/p>\n\n\n\n<p>Then check again if the Excel drivers are installed and in the right version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How to manage the 32-bit and 64-bit Excel driver versions?<\/h3>\n\n\n\n<p>Visual Studio works in 32-bit and SSIS works in 32-bit or 64-bit. It is therefore necessary to install the drivers corresponding to the project. This is a very complex topic as it is not possible to install 32-bit and 64-bit versions in parallel with the 2016 drivers. A more detailed article on this specific configuration will be written.<\/p>\n\n\n\n<p>If the Office version is installed in 64-bit, then avoid reinstalling all Office 365 applications. So, use this solution to run the package and load the Excel file without errors:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Install the <a href=\"https:\/\/expert-only.com\/en\/ssis\/access-database-engine-2016-excel-driver\/\">Excel Access Database Engine 2016<\/a> drivers for SSIS in <strong>64-bit<\/strong> version.<\/li>\n\n\n\n<li>Install the <a href=\"https:\/\/expert-only.com\/en\/excel-tips\/download-and-install-the-oledb-driver-for-excel-2010\/\">Excel 2010 driver<\/a> in <strong>32-bit<\/strong> version.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-change-column-types-at-the-output-of-the-excel-source-component\"><\/span>5. Change column types at the output of the Excel Source component<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, the type of an Excel text column is DT_WSTR with a length of 255 characters. Indeed, during an import with SSIS, all new connection to an Excel file as the default values.<\/p>\n\n\n\n<p>From the <em>Advanced Editor for Excel Source<\/em>, choose the data type <strong>DT_I8<\/strong> for the CustomerID column which is of integer type in the table. Open the editor by <strong>right-clicking<\/strong> on the <strong>Excel Source<\/strong> component. Modify only the Output Columns section.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"823\" height=\"879\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-8-configure-data-type-int.jpg\" alt=\"Change the Excel Source Customer ID column output to integer  \" class=\"wp-image-12239\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-8-configure-data-type-int.jpg 823w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-8-configure-data-type-int-281x300.jpg 281w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-8-configure-data-type-int-768x820.jpg 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><figcaption class=\"wp-element-caption\">Change the Excel Source Customer ID column output to integer  <\/figcaption><\/figure><\/div>\n\n\n<p>Choose the data type DT_WSTR for all other columns and adjust the length to the lengths in the customer table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"823\" height=\"879\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-9-configure-data-type-nvarchar.jpg\" alt=\"Changing the type of columns in the SSIS Advanced Editor for Excel Source\" class=\"wp-image-12243\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-9-configure-data-type-nvarchar.jpg 823w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-9-configure-data-type-nvarchar-281x300.jpg 281w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-9-configure-data-type-nvarchar-768x820.jpg 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><figcaption class=\"wp-element-caption\">Changing the type of columns in the SSIS Advanced Editor for Excel Source<\/figcaption><\/figure><\/div>\n\n\n<p>Open the Excel Source Editor component and change the Error Output section to ignore data truncation errors. Use this if you are sure that the file does not contain data with an incorrect length.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"844\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-10-ignore-failure-troncation.jpg\" alt=\"Configure the SSIS truncation error handling option in the Excel Source Editor\" class=\"wp-image-12255\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-10-ignore-failure-troncation.jpg 858w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-10-ignore-failure-troncation-300x295.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-10-ignore-failure-troncation-768x755.jpg 768w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><figcaption class=\"wp-element-caption\"><em>Configure the SSIS truncation error handling option in the Excel Source Editor<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-configure-the-sql-server-target-table-to-import-the-excel-file\"><\/span>6. Configure the SQL Server target table to import the Excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now, in the SSIS Toolbox, select the type of destination to load the Excel file into. From the <em>Other Destinations<\/em> section, choose <em>OLE DB Destination<\/em>. And drag the component into the data flow. Then link the two components, Excel Source to OLE DB Destination with the arrow.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-7-add-ole-db-destination.jpg\" alt=\"Prepare the connection to the SQL Server database with the SSIS OLE DB Destination component\" class=\"wp-image-12229\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-7-add-ole-db-destination.jpg 560w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-7-add-ole-db-destination-300x300.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-7-add-ole-db-destination-150x150.jpg 150w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><figcaption class=\"wp-element-caption\">Prepare the connection to the SQL Server database with the SSIS OLE DB Destination component<\/figcaption><\/figure><\/div>\n\n\n<p>Then double click on OLE DB destination and choose the database to load the file into. <a href=\"https:\/\/expert-only.com\/en\/ssis\/create-a-connection-to-sql-server-database-in-ssis\/\">Create the database connection<\/a> beforehand. The data mapping is automatic because it is based on the column names which are the same between the Excel file and the SQL Server table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"844\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-11-ole-db-destination-mapping.jpg\" alt=\"Check the mapping of the columns to be loaded from the Excel file to the SQL Server table\" class=\"wp-image-12263\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-11-ole-db-destination-mapping.jpg 858w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-11-ole-db-destination-mapping-300x295.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-11-ole-db-destination-mapping-768x755.jpg 768w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><figcaption class=\"wp-element-caption\">Check the mapping of the columns to be loaded from the Excel file to the SQL Server table<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-run-the-ssis-package-and-import-excel-data-into-sql-server\"><\/span>7. Run the SSIS package and import Excel data into SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, click on the run button at the top of the page. Or press <strong>F5<\/strong>, to run the package. The SSIS run starts to import the data from the Excel file into the SQL Server database. The SSIS Excel Source and OLE DB Destination components turn green, so it is a successful run.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-12-package-execution-success.jpg\" alt=\"Run the SSIS package to import the data from the Excel file into the table\" class=\"wp-image-12267\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-12-package-execution-success.jpg 540w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-12-package-execution-success-300x244.jpg 300w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><figcaption class=\"wp-element-caption\">Run the SSIS package to import the data from the Excel file into the table<\/figcaption><\/figure><\/div>\n\n\n<p>In addition, the number of rows used is visible on the Visual Studio screen. The yellow warning sign indicates a potential truncation of characters. To remove the warning, double check that the source and target columns have the same length in the metadata. For example NVARCHAR(20) for SQL Server and a compatible data type like (DT_WSTR,20) for SSIS.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-check-the-result-using-ssms-and-a-sql-query\"><\/span>8. Check the result using SSMS and a SQL query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After the SSIS import, check that the 48 rows in the Excel file are in the table without error. Execute these two queries from SSMS.<\/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 COUNT(*) AS [LINES]\n  FROM [dbo].[Customers];\n\nSELECT * \n  FROM [dbo].[Customers];<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"700\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-13-check-database-results.jpg\" alt=\"Run the query in SSMS to check the rows imported from the Excel file to SQL Server\" class=\"wp-image-12272\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-13-check-database-results.jpg 500w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-excel-13-check-database-results-214x300.jpg 214w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><figcaption class=\"wp-element-caption\"><em>Run the query in SSMS to check the rows imported from the Excel file to SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Conclusion on Excel data import with SSIS<\/h3>\n\n\n\n<p>To conclude, this tutorial shows how to import an Excel file into a SQL Server table with SSIS, and it is not especially difficult. But the configuration of the development environment and in particular the management of the Excel drivers with 32-bit and 64-bit versions makes the task more complex. Finally, here is another <a href=\"https:\/\/expert-only.com\/en\/ssis\/import-text-file-into-sql-server-database-with-ssis\/\">tutorial for importing a text file in CSV format into a SQL Server database with SSIS<\/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=\"GrIO5wXWme\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-csv-file-into-sql-server-with-ssis\/\">Import CSV file into SQL Server using 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 CSV file into SQL Server using SSIS&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/import-csv-file-into-sql-server-with-ssis\/embed\/#?secret=oJZMQrUbHB#?secret=GrIO5wXWme\" data-secret=\"GrIO5wXWme\" 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>Import an Excel file into a SQL Server table with an SSIS package. Step by step tutorial to import data from an Excel file (xslx) into a SQL Server table with an SSIS package. Here, the target is a <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\" title=\"Import an Excel file into a SQL table with SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[417],"class_list":{"0":"post-13204","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis","8":"tag-file"},"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 an Excel file into a SQL table with SSIS - MS BI<\/title>\n<meta name=\"description\" content=\"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.\" \/>\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-file-into-sql-table-with-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import an Excel file into a SQL table with SSIS\" \/>\n<meta property=\"og:description\" content=\"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-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=\"2022-09-06T05:06:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-16T16:41:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_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=\"10 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-file-into-sql-table-with-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Import an Excel file into a SQL table with SSIS\",\"datePublished\":\"2022-09-06T05:06:00+00:00\",\"dateModified\":\"2023-05-16T16:41:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\"},\"wordCount\":1387,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"keywords\":[\"File\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\",\"name\":\"Import an Excel file into a SQL table with SSIS - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"datePublished\":\"2022-09-06T05:06:00+00:00\",\"dateModified\":\"2023-05-16T16:41:34+00:00\",\"description\":\"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import an Excel file into a SQL table with SSIS\"}]},{\"@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 an Excel file into a SQL table with SSIS - MS BI","description":"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.","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-file-into-sql-table-with-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Import an Excel file into a SQL table with SSIS","og_description":"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.","og_url":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-09-06T05:06:00+00:00","article_modified_time":"2023-05-16T16:41:34+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_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":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Import an Excel file into a SQL table with SSIS","datePublished":"2022-09-06T05:06:00+00:00","dateModified":"2023-05-16T16:41:34+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/"},"wordCount":1387,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","keywords":["File"],"articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/","url":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/","name":"Import an Excel file into a SQL table with SSIS - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","datePublished":"2022-09-06T05:06:00+00:00","dateModified":"2023-05-16T16:41:34+00:00","description":"To import data from an Excel file into a SQL Server table with an SSIS package, use the Excel Source component and the OLE DB destination.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-B4BACF3D6C0_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Import an Excel file into a SQL table with SSIS"}]},{"@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\/13204","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=13204"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/13204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10734"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=13204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=13204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=13204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}