{"id":23515,"date":"2022-09-12T07:36:00","date_gmt":"2022-09-12T05:36:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=23515"},"modified":"2024-01-22T18:27:53","modified_gmt":"2024-01-22T17:27:53","slug":"export-sql-server-data-to-excel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/","title":{"rendered":"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Step by step video tutorial to develop an Integration Services package and export data from a SQL Server table into an Excel file.<\/em><\/h4>\n\n\n\n<p>This video tutorial explains how to export a SQL Server data from a table to an Excel file with an SSIS package. To manage the contents of this table within an Excel file, begin by creating an SSIS solution, project, and package. Then, follow the step-by-step instructions below to export the table rows to the Excel file.<\/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\/export-sql-server-data-to-excel\/#full-video-tutorial-to-export-data-from-sql-server-to-an-excel-file\" >Full Video tutorial to export data from SQL Server to an Excel File<\/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\/export-sql-server-data-to-excel\/#1-check-or-install-the-excel-2010-or-2016-drivers\" >1. Check or install the Excel 2010 or 2016 drivers<\/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\/export-sql-server-data-to-excel\/#2-create-the-table-to-export-from-sql-server-to-excel\" >2. Create the table to export from SQL Server to Excel<\/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\/export-sql-server-data-to-excel\/#3-create-an-ssis-data-flow-from-the-table-to-excel\" >3. Create an SSIS data flow from the table to Excel<\/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\/export-sql-server-data-to-excel\/#4-set-up-an-ssis-connection-to-the-excel-file\" >4. Set up an SSIS connection 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-6\" href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#5-execute-package-to-export-data-from-the-table-to-the-excel-file\" >5. Execute package to export data from the table 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-7\" href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#6-check-the-data-exported-into-the-excel-file\" >6. Check the data exported into the Excel file<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-full-video-tutorial-to-export-data-from-sql-server-to-an-excel-file\"><span class=\"ez-toc-section\" id=\"full-video-tutorial-to-export-data-from-sql-server-to-an-excel-file\"><\/span>Full Video tutorial to export data from SQL Server to an Excel File <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to export data from SQL Server to Excel with SSIS ?\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/5SzHmg438ZY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\"><strong><em>Video tutorial on exporting SQL Server data to Excel using SSIS<\/em><\/strong><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-check-or-install-the-excel-2010-or-2016-drivers\"><span class=\"ez-toc-section\" id=\"1-check-or-install-the-excel-2010-or-2016-drivers\"><\/span>1. Check or install the Excel 2010 or 2016 drivers<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, download and install the OLEDB Access Database Engine 2016 driver for Excel. This configuration works with Excel and the Office 365 pack installed in 64-bit and Visual Studio 2019. These 2 steps, in this order worked for me.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Install the <a href=\"https:\/\/expert-only.com\/en\/ssis\/access-database-engine-2016-excel-driver\/\">64-bit Excel 2016 driver<\/a> first.<\/li>\n\n\n\n<li>Then install the <a href=\"https:\/\/expert-only.com\/en\/excel\/download-oledb-excel-2010-driver\/\">32-bit Excel 2010 driver<\/a>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-create-the-table-to-export-from-sql-server-to-excel\"><\/span>2. Create the table to export from SQL Server to Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>From an SSMS Window, create the customer table using the code from this tutorial on exporting a table to a CSV file.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" 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\n\n-- Insert 24 rows with customer data\nINSERT INTO [dbo].[Customers] VALUES (1, N'Ali', N'Ahmed', N'Cairo', N'Egypt');\nINSERT INTO [dbo].[Customers] VALUES (2, N'Johnny', N'John', N'Toronto', N'Canada');\nINSERT INTO [dbo].[Customers] VALUES (3, N'John', N'Doe', N'Mexico City', N'Mexico');\nINSERT INTO [dbo].[Customers] VALUES (4, N'Shu', N'Abbas', N'Paris', N'France');\nINSERT INTO [dbo].[Customers] VALUES (5, N'Jeane', N'Raffin', N'Liushutun', N'China');\nINSERT INTO [dbo].[Customers] VALUES (6, N'Legra', N'Leate', N'B\u0142aszki', N'Poland');\nINSERT INTO [dbo].[Customers] VALUES (7, N'Sullivan', N'Goadby', N'Xiaoguwei', N'China');\nINSERT INTO [dbo].[Customers] VALUES (8, N'Tom', N'Ellams', N'Lop Buri', N'Thailand');\nINSERT INTO [dbo].[Customers] VALUES (9, N'Trace', N'Fowell', N'Sriwing', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (10, N'Christoffer', N'Rochford', N'Mburukullu', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (11, N'Dru', N'Dunridge', N'Mistrat\u00f3', N'Colombia');\nINSERT INTO [dbo].[Customers] VALUES (12, N'Dud', N'Gravenor', N'Sandaogou', N'China');\nINSERT INTO [dbo].[Customers] VALUES (13, N'Lori', N'Garshore', N'Jeziora Wielkie', N'Poland');\nINSERT INTO [dbo].[Customers] VALUES (14, N'Cordy', N'Kentish', N'Vydreno', N'Russia');\nINSERT INTO [dbo].[Customers] VALUES (15, N'Ancell', N'Wileman', N'Claresholm', N'Canada');\nINSERT INTO [dbo].[Customers] VALUES (16, N'Elsworth', N'Chantrell', N'Sumberjo', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (17, N'Beverly', N'Giraudy', N'Cigembong', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (18, N'Tamas', N'Zavattiero', N'Jangkat', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (19, N'Benedick', N'Schaffler', N'Itaparica', N'Brazil');\nINSERT INTO [dbo].[Customers] VALUES (20, N'Leonard', N'Brimman', N'Moscow', N'Russia');\nINSERT INTO [dbo].[Customers] VALUES (21, N'Morton', N'Capelle', N'Uk', N'Russia');\nINSERT INTO [dbo].[Customers] VALUES (22, N'Larissa', N'Rawle', N'Tembayangan Barat', N'Indonesia');\nINSERT INTO [dbo].[Customers] VALUES (23, N'Karalee', N'Wall', N'Clifden', N'Ireland');\nINSERT INTO [dbo].[Customers] VALUES (24, N'Miller', N'Shakesbye', N'Gongnong', N'China');\n<\/pre>\n\n\n\n<p>After inserting the 24 rows into the customer table to export, this sample dataset will be used to execute the package and obtain a real-life result in the Excel file. Of course, your data and environment might vary, but the principles are the same.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"520\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-csv-file-1-create-table-insert-data-1.jpg\" alt=\"Use SSMS to run the code and create the sample table and insert 24 rows of data\" class=\"wp-image-12477\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-csv-file-1-create-table-insert-data-1.jpg 760w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-csv-file-1-create-table-insert-data-1-300x205.jpg 300w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Use SSMS to run the code and create the sample table and insert 24 rows of data<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>To simplify data mapping, prepare an Excel file in XLSX format and add column names beforehand. In this case, the column names are as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>CustomerID<\/li>\n\n\n\n<li>FirstName<\/li>\n\n\n\n<li>LastName<\/li>\n\n\n\n<li>City<\/li>\n\n\n\n<li>Country<\/li>\n<\/ol>\n\n\n\n<p>Prepare the header row of the target Excel file to map the columns from SSIS. The file used here is stored at: <strong>C:\\data\\Customers_Export.xlsx<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-create-an-ssis-data-flow-from-the-table-to-excel\"><\/span>3. Create an SSIS data flow from the table to Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>From the Data Flow tab, add <a href=\"https:\/\/en.wikipedia.org\/wiki\/OLE_DB\" target=\"_blank\" rel=\"noreferrer noopener\">the OLE DB<\/a> Source and Excel Destination components to the workspace. Then, double-click the first component to configure it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-2-add-ole-db-source-excel-destination.jpg\" alt=\"Add the OLE DB Source and Excel Destination components to the SSIS data flow.\" class=\"wp-image-12618\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-2-add-ole-db-source-excel-destination.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-2-add-ole-db-source-excel-destination-300x281.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Add the OLE DB Source and Excel Destination components to the SSIS data flow<\/figcaption><\/figure><\/div>\n\n\n<p>Once in the OLE DB Source Editor options window, select the database connection and the customer table to export to the Excel file. Finally, confirm to close the window.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"480\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-3-set-ole-db-source.jpg\" alt=\"Select the connection and source table to export to Excel\" class=\"wp-image-12623\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-3-set-ole-db-source.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-3-set-ole-db-source-300x212.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-3-set-ole-db-source-678x480.jpg 678w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Select the connection and the SQL Server source table to export to Excel<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>The following steps will help you configure the link to the exported Excel file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-set-up-an-ssis-connection-to-the-excel-file\"><\/span>4. Set up an SSIS connection to the Excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After configuring the OLE DB Source component, use the empty Excel file with headers to receive the data. To export data to the Excel file, connect the OLE DB Source component to the Excel Destination component using the green arrow. Then, create an Excel connection as follows, 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=\"707\" height=\"444\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-4-set-file-path.jpg\" alt=\"Add a connection to the Excel file from the SSIS connection manager section\" class=\"wp-image-12646\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-4-set-file-path.jpg 707w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-4-set-file-path-300x188.jpg 300w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Add a connection to the Excel file from the SSIS connection manager section<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Next, double-click the Excel component. In the Excel Destination Editor, choose the Excel file connection created earlier. Also, select which tab to export the data to; in this case, it is the default English tab, <strong><em>Sheet1$<\/em><\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-5-set-excel-connection.jpg\" alt=\"Configure the SSIS component to export data into the Excel file\" class=\"wp-image-12652\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-5-set-excel-connection.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-5-set-excel-connection-300x203.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-5-set-excel-connection-678x460.jpg 678w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Configure the SSIS component to export data into the Excel file<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Click on <strong>Mappings<\/strong>, and if necessary, manually match the columns by clicking on Ignore and then choosing the appropriate column. Confirm to close the window.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-6-check-mapping.jpg\" alt=\"Verify the SSIS mapping before exporting the SQL data to the Excel document\" class=\"wp-image-12660\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-6-check-mapping.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-6-check-mapping-300x263.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Verify the SSIS mapping before exporting the SQL data to the Excel document<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-execute-package-to-export-data-from-the-table-to-the-excel-file\"><\/span>5. Execute package to export data from the table to the Excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, execute the Integration Services package by pressing the <strong>F5 key<\/strong>. The various components, i.e., the control flow, the data flow, the source table and the target file, turn green. The number of loaded rows is displayed and is correct, with 24 rows of data in the export. The loading process is successful.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"641\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-7-execute-xlsx-export.jpg\" alt=\"Execute the SSIS package to export the table to an Excel file\" class=\"wp-image-12672\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-7-execute-xlsx-export.jpg 641w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-7-execute-xlsx-export-300x215.jpg 300w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Execute the SSIS package to export the table to an Excel file<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-check-the-data-exported-into-the-excel-file\"><\/span>6. Check the data exported into the Excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After the package execution, open the exported Excel file and check the content, which should match exactly the customers table, i.e., dbo.Customers.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"810\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-8-check-xlsx-content.jpg\" alt=\"The content of the Excel file matches the SQL Server source table\" class=\"wp-image-12676\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-8-check-xlsx-content.jpg 590w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-8-check-xlsx-content-219x300.jpg 219w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><figcaption class=\"wp-element-caption\"><strong><em>The content of the Excel file matches the SQL Server source table<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Conclusion on exporting data from SQL Server to Excel using SSIS<\/h3>\n\n\n\n<p>This tutorial demonstrates how to export SQL Server data to an Excel file with an SSIS package and Visual Studio 2019. The basic data export is relatively quick and easy to set up. To best manage data types, it is recommended to use file templates that are copied before executing the export task. It is also possible to export a table to a file using the SQL Server import and export wizard.<\/p>\n\n\n\n<p>To go even further, let&#8217;s check out how to do the opposite operation, i.e. import an excel file into a MS SQL table.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"n9KzyqkCbf\"><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=yPbtwEccVT#?secret=n9KzyqkCbf\" data-secret=\"n9KzyqkCbf\" 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>Step by step video tutorial to develop an Integration Services package and export data from a SQL Server table into an Excel file. This video tutorial explains how to export a SQL Server data from a table to an <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\" title=\"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10819,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[417],"class_list":{"0":"post-23515","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>Export data from SQL Server to Excel with SSIS - Video Tutorial<\/title>\n<meta name=\"description\" content=\"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.\" \/>\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\/export-sql-server-data-to-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial\" \/>\n<meta property=\"og:description\" content=\"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\" \/>\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-12T05:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-22T17:27:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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=\"6 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\/export-sql-server-data-to-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial\",\"datePublished\":\"2022-09-12T05:36:00+00:00\",\"dateModified\":\"2024-01-22T17:27:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\"},\"wordCount\":827,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"keywords\":[\"File\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\",\"name\":\"Export data from SQL Server to Excel with SSIS - Video Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"datePublished\":\"2022-09-12T05:36:00+00:00\",\"dateModified\":\"2024-01-22T17:27:53+00:00\",\"description\":\"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial\"}]},{\"@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":"Export data from SQL Server to Excel with SSIS - Video Tutorial","description":"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.","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\/export-sql-server-data-to-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial","og_description":"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.","og_url":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-09-12T05:36:00+00:00","article_modified_time":"2024-01-22T17:27:53+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial","datePublished":"2022-09-12T05:36:00+00:00","dateModified":"2024-01-22T17:27:53+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/"},"wordCount":827,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","keywords":["File"],"articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/","url":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/","name":"Export data from SQL Server to Excel with SSIS - Video Tutorial","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","datePublished":"2022-09-12T05:36:00+00:00","dateModified":"2024-01-22T17:27:53+00:00","description":"Video tutorial to develop an SSIS package to export data from SQL Server to Excel file using data flow, OLE DB source and Excel components.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to export data from SQL Server table into Excel file using SSIS? Video Tutorial"}]},{"@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\/23515","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=23515"}],"version-history":[{"count":4,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/23515\/revisions"}],"predecessor-version":[{"id":29731,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/23515\/revisions\/29731"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10819"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=23515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=23515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=23515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}