{"id":1268,"date":"2022-09-12T07:36:00","date_gmt":"2022-09-12T05:36:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1268"},"modified":"2023-03-14T12:05:00","modified_gmt":"2023-03-14T11:05:00","slug":"exporter-table-sql-server-vers-excel-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/","title":{"rendered":"Exporter une table SQL Server vers un fichier Excel avec SSIS"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Tutoriel pour d\u00e9velopper un package SSIS et exporter les donn\u00e9es SQL Server dans un fichier Excel.<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel pour exporter une table SQL Server vers un fichier Excel depuis un package SSIS. Pour g\u00e9rer le contenu de cette table dans un fichier Excel, commencer par <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">cr\u00e9er une solution, un projet et un package SSIS<\/a>. Ensuite, suivre les \u00e9tapes ci-dessous pas \u00e0 pas pour exporter les lignes de la table dans le fichier Excel.<\/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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#1-verifier-ou-installer-la-presence-des-drivers-excel-2010-ou-2016\" >1. V\u00e9rifier ou installer la pr\u00e9sence des drivers Excel 2010 ou 2016<\/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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#2-preparer-la-table-sql-a-exporter-et-le-fichier-excel\" >2. Pr\u00e9parer la table SQL \u00e0 exporter et le fichier Excel<\/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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#3-creer-et-configurer-le-flux-de-donnees-de-la-table-vers-excel\" >3. Cr\u00e9er et configurer le flux de donn\u00e9es de la table vers 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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#4-configurer-lexport-vers-le-fichier-excel\" >4. Configurer l&rsquo;export vers le fichier 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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#5-executer-le-package-ssis-pour-exporter-la-table-et-verifier-les-donnees-dans-excel\" >5. Ex\u00e9cuter le package SSIS pour exporter la table et v\u00e9rifier les donn\u00e9es dans Excel<\/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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#conclusion-sur-lexport-depuis-sql-server-vers-excel-avec-ssis\" >Conclusion sur l&rsquo;export depuis SQL Server vers Excel avec SSIS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-verifier-ou-installer-la-presence-des-drivers-excel-2010-ou-2016\"><\/span>1. V\u00e9rifier ou installer la pr\u00e9sence des drivers Excel 2010 ou 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u00e9l\u00e9charger et installer au pr\u00e9alable le driver OLEDB Access Database Engin 2016 pour Excel. Avec cette  configuration : Excel et le pack Office 365 install\u00e9 en 64-bits et Visual Studio 2019, cette astuce fonctionne.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Installer d&rsquo;abord le <a href=\"https:\/\/expert-only.com\/ssis\/pilotes-access-database-engine-2016-excel-pour-ssis\/\">driver Excel 2016 en 64-bit<\/a><\/li>\n\n\n\n<li>Puis installer le <a href=\"https:\/\/expert-only.com\/astuces-excel\/driver-oledb-excel-2010\/\">driver Excel 2010 en 32-bit<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-preparer-la-table-sql-a-exporter-et-le-fichier-excel\"><\/span>2. Pr\u00e9parer la table SQL \u00e0 exporter et le fichier Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Avec SSMS, pour cr\u00e9er la table des clients, r\u00e9cup\u00e9rer le code depuis ce <a href=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-fichier-texte-ssis\/\">tutoriel pour exporter une table dans un fichier CSV<\/a>.<\/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=\"\">-- Cr\u00e9er la table des clients\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-- Ins\u00e9rer 24 lignes avec les donn\u00e9es des clients\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>Puis ins\u00e9rer les lignes suivantes dans la table des clients pour l\u2019export. Ce jeu de donn\u00e9es d\u2019exemple sert \u00e0 faire fonctionner le package et \u00e0 obtenir un r\u00e9sultat concret dans le fichier Excel.<\/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=\"Cr\u00e9er la table \u00e0 exporter depuis SSMS\" class=\"wp-image-12476\" 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\"><em>Ex\u00e9cuter le code pour cr\u00e9er la table des clients<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Pour faciliter le mapping des donn\u00e9es, pr\u00e9parer un fichier Excel au format XLSX et ajouter les noms de colonnes au pr\u00e9alable. Ici les noms de colonnes sont les suivants: <\/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<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"240\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-1-prepare-excel-header-2.jpg\" alt=\"Pr\u00e9parer la ligne d'ent\u00eate du fichier Excel cible pour mapper les colonnes depuis SSIS\" class=\"wp-image-12611\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-1-prepare-excel-header-2.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-data-to-excel-1-prepare-excel-header-2-300x100.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><em>Pr\u00e9parer la ligne d&rsquo;ent\u00eate du fichier Excel cible pour mapper les colonnes depuis SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Le fichier pr\u00e9sent\u00e9 ici est stock\u00e9 ici : <strong>C:\\data\\Customers_Export.xlsx<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-creer-et-configurer-le-flux-de-donnees-de-la-table-vers-excel\"><\/span>3. Cr\u00e9er et configurer le flux de donn\u00e9es de la table vers Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Depuis l&rsquo;onglet Data Flow, ajouter les composants <em>OLE DB Source<\/em> et <em>Excel Destination<\/em> sur l&rsquo;espace de travail. Double cliquer ensuite sur le premier pour le configurer.<\/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=\"Ajouter les composants OLE DB Source et Excel Destination au flux de donn\u00e9es SSIS\" class=\"wp-image-12617\" 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\"><em>Ajouter les composants OLE DB Source et Excel Destination au flux de donn\u00e9es SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Une fois dans la fen\u00eatre des options <em>OLE DB Source Editor<\/em>, s\u00e9lectionner la connexion \u00e0 la base de donn\u00e9es et la table des clients \u00e0 exporter dans le fichier Excel. Enfin, valider pour fermer la fen\u00eatre.<\/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=\"S\u00e9lectionner la connexion et la table source \u00e0 exporter vers Excel\" class=\"wp-image-12622\" 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\"><em>S\u00e9lectionner la connexion et la table source \u00e0 exporter vers Excel<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Les \u00e9tapes suivantes permettent de configure le lien vers le fichier Excel export\u00e9.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configurer-lexport-vers-le-fichier-excel\"><\/span>4. Configurer l&rsquo;export vers le fichier Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Apr\u00e8s avoir configurer le composant <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/integration-services\/connection-manager\/ole-db-connection-manager?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">OLE DB Source<\/a>, utiliser le fichier Excel vide avec les ent\u00eates pour recevoir les donn\u00e9es. Pour exporter des donn\u00e9es vers le fichier Excel. Relier le composant <em>OLE DB Source<\/em> au composant <em>Excel Destination<\/em> via la fl\u00e8che verte. Cr\u00e9er ensuite une connexion Excel comme suit, depuis le gestionnaire de connexions SSIS.<\/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=\"Ajouter une connexion au fichier Excel depuis le gestionnaire de connexions\" class=\"wp-image-12645\" 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\"><em>Ajouter une connexion au fichier Excel depuis le gestionnaire de connexions<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Puis double cliquer sur le composant Excel.&nbsp;Dans <em>Excel Destination Editor<\/em> choisir la connexion au fichier Excel cr\u00e9\u00e9e auparavant. Choisir \u00e9galement dans quel onglet exporter les donn\u00e9es, ici c&rsquo;est l&rsquo;onglet par d\u00e9faut en Anglais, c&rsquo;est \u00e0 dire <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=\"Configurer le composant SSIS pour exporter les donn\u00e9es dans le fichier Excel\" class=\"wp-image-12651\" 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\"><em>Configurer le composant SSIS pour exporter les donn\u00e9es dans le fichier Excel<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Cliquer ensuite sur <em>Mappings<\/em>, si n\u00e9cessaire, faire correspondre manuellement les colonnes. Pour cela, cliquer sur Ignore et puis choisir colonne ad\u00e9quate. Valider pour fermer la fen\u00eatre.<\/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=\"V\u00e9rifier le mapping SSIS avant d'exporter la table dans le fichier Excel\" class=\"wp-image-12659\" 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\"><em>V\u00e9rifier le mapping SSIS avant d&rsquo;exporter la table dans le fichier Excel<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-executer-le-package-ssis-pour-exporter-la-table-et-verifier-les-donnees-dans-excel\"><\/span>5. Ex\u00e9cuter le package SSIS pour exporter la table et v\u00e9rifier les donn\u00e9es dans Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, ex\u00e9cuter le chargement. Pour cela, appuyer sur la touche F5, les diff\u00e9rents composants, c&rsquo;est \u00e0 dire le flux de contr\u00f4le, le flux de donn\u00e9es, la source et la cible deviennent verts. Le nombre de lignes charg\u00e9es s&rsquo;affiche et il est correct, soit 24 lignes. Le chargement s&rsquo;est donc effectu\u00e9 correctement.<\/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=\"Ex\u00e9cuter le package SSIS pour exporter la table dans un fichier Excel\" class=\"wp-image-12671\" 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\"><em>Ex\u00e9cuter le package SSIS pour exporter la table dans un fichier Excel<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Ouvrir enfin le fichier Excel export\u00e9 et contr\u00f4ler le contenu qui doit \u00eatre identique \u00e0 celui de la table des clients, c&rsquo;est \u00e0 dire 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=\"Le contenu du fichier Excel est conforme \u00e0 la table source\" class=\"wp-image-12675\" 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\"><em>Le contenu du fichier Excel est conforme \u00e0 la table source<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-sur-lexport-depuis-sql-server-vers-excel-avec-ssis\"><\/span>Conclusion sur l&rsquo;export depuis SQL Server vers Excel avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici donc comment exporter une table depuis SQL Server dans un fichier Excel avec un package SSIS. L&rsquo;export de donn\u00e9es basique est relativement rapide et facile \u00e0 mettre en place. Pour g\u00e9rer au mieux les types de donn\u00e9es il est conseill\u00e9 d&rsquo;utiliser des mod\u00e8les de fichiers \u00e0 copier avant l&rsquo;ex\u00e9cution de la t\u00e2che d&rsquo;export. Il est \u00e9galement possible d&rsquo;<a href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\">exporter une table vers un fichier avec l&rsquo;assistant import et export SQL Server<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"owtKP8WbOc\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/pilotes-access-database-engine-2016-ssis\/\">PilotesAccess Database Engine 2016 et import Excel avec 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=\"\u00ab\u00a0PilotesAccess Database Engine 2016 et import Excel avec SSIS\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/pilotes-access-database-engine-2016-ssis\/embed\/#?secret=8RaY2Y4fiG#?secret=owtKP8WbOc\" data-secret=\"owtKP8WbOc\" 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>Tutoriel pour d\u00e9velopper un package SSIS et exporter les donn\u00e9es SQL Server dans un fichier Excel. Tutoriel pour exporter une table SQL Server vers un fichier Excel depuis un package SSIS. Pour g\u00e9rer le contenu de cette table dans <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\" title=\"Exporter une table SQL Server vers un fichier Excel avec SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[99],"class_list":{"0":"post-1268","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis","8":"tag-fichier"},"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>Exporter une table SQL Server vers un fichier Excel avec SSIS<\/title>\n<meta name=\"description\" content=\"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.\" \/>\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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporter une table SQL Server vers un fichier Excel avec SSIS\" \/>\n<meta property=\"og:description\" content=\"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\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=\"2023-03-14T11:05:00+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=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Exporter une table SQL Server vers un fichier Excel avec SSIS\",\"datePublished\":\"2022-09-12T05:36:00+00:00\",\"dateModified\":\"2023-03-14T11:05:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\"},\"wordCount\":814,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"keywords\":[\"Fichier\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\",\"name\":\"Exporter une table SQL Server vers un fichier Excel avec SSIS\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"datePublished\":\"2022-09-12T05:36:00+00:00\",\"dateModified\":\"2023-03-14T11:05:00+00:00\",\"description\":\"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exporter une table SQL Server vers un fichier Excel avec SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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":"Exporter une table SQL Server vers un fichier Excel avec SSIS","description":"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.","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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Exporter une table SQL Server vers un fichier Excel avec SSIS","og_description":"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-09-12T05:36:00+00:00","article_modified_time":"2023-03-14T11:05:00+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":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Exporter une table SQL Server vers un fichier Excel avec SSIS","datePublished":"2022-09-12T05:36:00+00:00","dateModified":"2023-03-14T11:05:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/"},"wordCount":814,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","keywords":["Fichier"],"articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/","name":"Exporter une table SQL Server vers un fichier Excel avec SSIS","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","datePublished":"2022-09-12T05:36:00+00:00","dateModified":"2023-03-14T11:05:00+00:00","description":"Pour exporter une table SQL Server dans un fichier Excel avec SSIS, cr\u00e9er un data flow, une source OLE DB et une cible Excel via ODBC.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#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\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Exporter une table SQL Server vers un fichier Excel avec SSIS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/wp-json\/wp\/v2\/posts\/1268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1268"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10817"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}