{"id":12857,"date":"2023-04-03T05:36:00","date_gmt":"2023-04-03T03:36:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=12857"},"modified":"2023-05-10T11:28:49","modified_gmt":"2023-05-10T09:28:49","slug":"exporter-une-table-sql-en-xml-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/","title":{"rendered":"Exporter une table SQL Server dans un fichier XML avec SSIS"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Exporter les donn\u00e9es depuis une table SQL Server vers un fichier au format XML avec SSIS.<\/em><\/strong><\/h4>\n\n\n\n<p>Pour exporter une table SQL Server au dans un fichier de type XML avec un package SSIS et sans composant additionnel, il faut transformer les donn\u00e9es SQL en XML avec une requ\u00eate. SSIS ne fournit pas de composant natif XML, il existe seulement la source XML. D&rsquo;autres \u00e9diteurs de logiciels proposent des composants pour exporter en XML, comme le package <a href=\"https:\/\/www.kingswaysoft.com\/products\/ssis-productivity-pack\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS productivity pack<\/a> de KingswaySoft par exemple.<\/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-une-table-sql-en-xml-avec-ssis\/#tutoriel-ssis-pour-exporter-des-donnees-sql-au-format-xml\" >Tutoriel SSIS pour exporter des donn\u00e9es SQL au format XML<\/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-une-table-sql-en-xml-avec-ssis\/#1-creer-la-table-sql-source-avec-les-donnees-a-exporter-en-xml\" >1. Cr\u00e9er la table SQL source avec les donn\u00e9es \u00e0 exporter en XML<\/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-une-table-sql-en-xml-avec-ssis\/#2-construire-la-requete-pour-transformer-les-donnees-sql-en-xml\" >2. Construire la requ\u00eate pour transformer les donn\u00e9es SQL en XML<\/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-une-table-sql-en-xml-avec-ssis\/#3-configurer-le-flux-ssis-depuis-la-table-sql-source-vers-le-fichier-xml\" >3. Configurer le flux SSIS depuis la table SQL source vers le fichier XML<\/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-une-table-sql-en-xml-avec-ssis\/#4-configurer-le-fichier-xml-a-exporter-depuis-ssis\" >4. Configurer le fichier XML \u00e0 exporter depuis SSIS<\/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-une-table-sql-en-xml-avec-ssis\/#5-executer-le-package-pour-exporter-la-table-en-xml-et-verifier-le-contenu\" >5. Ex\u00e9cuter le package pour exporter la table en XML et v\u00e9rifier le contenu<\/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\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#conclusion-sur-lexport-de-fichier-en-xml-avec-ssis\" >Conclusion sur l&rsquo;export de fichier en XML avec SSIS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"tutoriel-ssis-pour-exporter-des-donnees-sql-au-format-xml\"><\/span>Tutoriel SSIS pour exporter des donn\u00e9es SQL au format XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour exporter les donn\u00e9es de la table au fichier XML, voici les \u00e9tapes. Cr\u00e9er la table d&rsquo;exemple, construire la requ\u00eate source avec les <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/xml\/xml-data-sql-server?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">fonctions XML SQL Server natives<\/a>, configurer le composant OLE DB source puis le composant Fat File Destination, et enfin ex\u00e9cuter le package.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-la-table-sql-source-avec-les-donnees-a-exporter-en-xml\"><span class=\"ez-toc-section\" id=\"1-creer-la-table-sql-source-avec-les-donnees-a-exporter-en-xml\"><\/span>1. Cr\u00e9er la table SQL source avec les donn\u00e9es \u00e0 exporter en XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\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 8 lignes \u00e0 exporter au format XML\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');<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-construire-la-requete-pour-transformer-les-donnees-sql-en-xml\"><\/span>2. Construire la requ\u00eate pour transformer les donn\u00e9es SQL en XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Apr\u00e8s avoir cr\u00e9\u00e9 la table et ins\u00e9rer les donn\u00e9es des clients, construire la requ\u00eate SQL Server pour transformer les donn\u00e9es SQL en XML. Voici tout d&rsquo;abord une requ\u00eate SQL classique pour s\u00e9lectionner les donn\u00e9es.<\/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=\"\">-- Requ\u00eate SQL classique pour s\u00e9lectioner les donn\u00e9es clients\nSELECT\n\t[CustomerID],\n\t[FirstName],\n\t[LastName],\n\t[City],\n\t[Country]\nFROM [dbo].[Customers]; <\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-1-check-source-data-ssms.jpg\" alt=\"V\u00e9rifier les donn\u00e9es dans la table source avec SSMS\" class=\"wp-image-12869\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-1-check-source-data-ssms.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-1-check-source-data-ssms-300x270.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier les donn\u00e9es dans la table source avec SSMS<\/figcaption><\/figure><\/div>\n\n\n<p>Voici maintenant la requ\u00eate avec les fonctions XML pour cr\u00e9er les \u00e9l\u00e9ments XML <em>Customers<\/em> et <em>Customer<\/em>.<\/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=\"\">-- Requ\u00eate XML\nSELECT \n\t[CustomerID],\n\t[FirstName],\n\t[LastName],\n\t[City],\n\t[Country]\t\nFROM [dbo].[Customers]\nFOR XML PATH('Customer'),\n\t\tROOT('Customers'),\n\t\t\tELEMENTS XSINIL;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-2-build-xml-query.jpg\" alt=\"Modifier la requ\u00eate SQL pour transformer les lignes au format XML\" class=\"wp-image-12875\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-2-build-xml-query.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-2-build-xml-query-300x230.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-2-build-xml-query-80x60.jpg 80w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Modifier la requ\u00eate SQL pour transformer les lignes au format XML<\/figcaption><\/figure><\/div>\n\n\n<p>Cliquer sur le lien dans le r\u00e9sultat pour afficher le fichier au format XML dans une nouvelle fen\u00eatre SSMS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-3-raw-xml-result.jpg\" alt=\"Table des clients au format XML depuis SSMS\" class=\"wp-image-12880\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-3-raw-xml-result.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-3-raw-xml-result-300x158.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Table des clients au format XML depuis SSMS<\/figcaption><\/figure><\/div>\n\n\n<p>Les donn\u00e9es retourn\u00e9es par la requ\u00eate XML sont de type IMAGE. C&rsquo;est \u00e0 dire que c&rsquo;est un fichier. Pour transformer le type IMAGE SQL Server en texte, inclure la requ\u00eate en tant que sous requ\u00eate. La colonne est \u00e9galement renomm\u00e9e en <em>XML_Column<\/em> pour faciliter <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-data-flow-ssis-simple\/\">le mapping depuis le flux de donn\u00e9es SSIS<\/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=\"\">SELECT (\n\tSELECT \n\t\t [CustomerID],\n\t\t [FirstName],\n\t\t [LastName],\n\t\t [City],\n\t\t [Country]\t\n\tFROM [dbo].[Customers]\n\tFOR XML PATH('Customer'),\n\t\t\tROOT('Customers'),\n\t\t\t\tELEMENTS XSINIL\n) AS XML_Column;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-4-xml-to-column-ssms.jpg\" alt=\"Requ\u00eate XML dans une sous requ\u00eate pour afficher du texte\" class=\"wp-image-12887\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-4-xml-to-column-ssms.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-4-xml-to-column-ssms-300x194.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-4-xml-to-column-ssms-678x440.jpg 678w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\">Requ\u00eate XML dans une sous requ\u00eate pour afficher du texte<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-configurer-le-flux-ssis-depuis-la-table-sql-source-vers-le-fichier-xml\"><\/span>3. Configurer le flux SSIS depuis la table SQL source vers le fichier XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ajouter les composant SSIS <em>OLE DB Source<\/em> et <em>Flat File Destination<\/em> dans le data flow.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-5-add-ole-db-and-flat-file.jpg\" alt=\"Flux de donn\u00e9es SSIS pour exporter une table SQL sans un fichier XML\" class=\"wp-image-12897\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-5-add-ole-db-and-flat-file.jpg 660w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-5-add-ole-db-and-flat-file-300x264.jpg 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><figcaption class=\"wp-element-caption\">Flux de donn\u00e9es SSIS pour exporter une table SQL sans un fichier XML<\/figcaption><\/figure><\/div>\n\n\n<p>Ouvrir le composant <em>OLE DB Source<\/em> et <a href=\"https:\/\/expert-only.com\/ssis\/creer-connexion-base-sql-server-ssis\/\">utiliser une connexion \u00e0 la base de donn\u00e9es<\/a> source. Entrer la requ\u00eate depuis l&rsquo;\u00e9tape pr\u00e9c\u00e9dente.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"680\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-6-add-sql-query-ole-db.jpg\" alt=\"Ins\u00e9rer la requ\u00eate source pour retourner la colonne au format XML\" class=\"wp-image-12903\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-6-add-sql-query-ole-db.jpg 660w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-6-add-sql-query-ole-db-291x300.jpg 291w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><figcaption class=\"wp-element-caption\">Ins\u00e9rer la requ\u00eate source pour retourner la colonne au format XML<\/figcaption><\/figure><\/div>\n\n\n<p>En cas de changement de requ\u00eate, v\u00e9rifier que le type de donn\u00e9es est bien de type <em>DT_NTEXT,<\/em> soit au format Texte Unicode, pour \u00e9viter les erreurs au niveau du mapping vers le fichier. Faire un <strong><em>clic-droit<\/em><\/strong> et choisir <strong><em>Show Advanced Editor<\/em><\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"879\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-7-advanced-editor-xml-column-dt_ntext.jpg\" alt=\"V\u00e9rifier le format de la colonne XML\" class=\"wp-image-12910\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-7-advanced-editor-xml-column-dt_ntext.jpg 816w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-7-advanced-editor-xml-column-dt_ntext-278x300.jpg 278w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-7-advanced-editor-xml-column-dt_ntext-768x827.jpg 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier le format de la colonne XML<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configurer-le-fichier-xml-a-exporter-depuis-ssis\"><\/span>4. Configurer le fichier XML \u00e0 exporter depuis SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Depuis le composant Flat File Destination, Cr\u00e9er une nouvelle connexion de type fichier plat. Choisir le type <em>Delimited<\/em>. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"780\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-8-new-flat-file.jpg\" alt=\"Cr\u00e9er une nouvelle connexion de type fichier plat pour exporter le fichier XML\" class=\"wp-image-12919\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-8-new-flat-file.jpg 820w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-8-new-flat-file-300x285.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-8-new-flat-file-768x731.jpg 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9er une nouvelle connexion de type fichier plat pour exporter le fichier XML<\/figcaption><\/figure><\/div>\n\n\n<p>Pour param\u00e9trer le fichier, suivre ces \u00e9tapes: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Renommer le fichier XML : <strong>XML File Export<\/strong><\/li>\n\n\n\n<li>Choisir le chemin sur le disque : <strong>C:\\data\\Customers_Data_Export.xml<\/strong><\/li>\n\n\n\n<li>S\u00e9lectionner <strong>Unicode<\/strong> pour assurer le mapping avec la colonne source. <\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"714\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-9-set-up-xml-file.jpg\" alt=\"Configurer les options du fichier cible XML \u00e0 exporter\" class=\"wp-image-12928\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-9-set-up-xml-file.jpg 729w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-9-set-up-xml-file-300x294.jpg 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><figcaption class=\"wp-element-caption\">Configurer les options du fichier cible XML \u00e0 exporter<\/figcaption><\/figure><\/div>\n\n\n<p>Par d\u00e9faut, Integration Services utiliser le type DT_WSTR avec une longueur de 255 caract\u00e8res. Param\u00e9trer maintenant la colonne.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Depuis l&rsquo;onglet <strong>Advanced<\/strong><\/li>\n\n\n\n<li>Renommer la colonne avec le m\u00eame nom que la source : <strong>XML_Column<\/strong><\/li>\n\n\n\n<li>Changer le type de donn\u00e9es et utiliser le type Texte Unicode: <strong>Unicode text stream [DT_NTEXT]<\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"775\" height=\"745\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-10-change-xml-column-dt_ntext.jpg\" alt=\"Renommer la colonne et changer le type en Unicode text stream DT_NTEXT\" class=\"wp-image-12938\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-10-change-xml-column-dt_ntext.jpg 775w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-10-change-xml-column-dt_ntext-300x288.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-10-change-xml-column-dt_ntext-768x738.jpg 768w\" sizes=\"auto, (max-width: 775px) 100vw, 775px\" \/><figcaption class=\"wp-element-caption\">Renommer la colonne et changer le type en Unicode text stream DT_NTEXT<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier aussi le mapping de la colonne depuis l&rsquo;onglet <em>Mappings<\/em>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-11-check-xml-file-mapping.jpg\" alt=\"Mapping depuis la table source SQL vers le fichier XML \u00e0 exporter\" class=\"wp-image-12945\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-11-check-xml-file-mapping.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-11-check-xml-file-mapping-300x220.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-11-check-xml-file-mapping-80x60.jpg 80w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Mapping depuis la table source SQL vers le fichier XML \u00e0 exporter<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-executer-le-package-pour-exporter-la-table-en-xml-et-verifier-le-contenu\"><\/span>5. Ex\u00e9cuter le package pour exporter la table en XML et v\u00e9rifier le contenu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter enfin le package pour exporter effectivement les donn\u00e9es dans le fichier XML. Une seule ligne est transf\u00e9r\u00e9e car la colonne contient l&rsquo;int\u00e9gralit\u00e9 du fichier au format XML et non des lignes classiques au format SQL.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export.jpg\" alt=\"Ex\u00e9cuter le package SSIS pour exporter la table dans le fichier XML\" class=\"wp-image-12952\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export-300x242.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Ex\u00e9cuter le package SSIS pour exporter la table dans le fichier XML<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier ensuite le fichier export\u00e9, c&rsquo;est \u00e0 dire depuis <em>C:\\data\\Customers_Data_Export.xml<\/em>. Ouvrir le fichier avec <a href=\"https:\/\/www.google.fr\/chrome\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Chrome<\/a> ou un autre <a href=\"https:\/\/www.mozilla.org\/fr\/firefox\/new\/\" target=\"_blank\" rel=\"noreferrer noopener\">navigateur Web open source comme Mozilla Firefox<\/a> par exemple. Et v\u00e9rifier les donn\u00e9es et la structure.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-13-check-xml-export-file-chrome.jpg\" alt=\"Ouvrir le fichier XML avec Google Chrome pour afficher la structure\" class=\"wp-image-12966\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-13-check-xml-export-file-chrome.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-13-check-xml-export-file-chrome-300x238.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\">Ouvrir le fichier XML avec Google Chrome pour afficher la structure<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-sur-lexport-de-fichier-en-xml-avec-ssis\"><\/span>Conclusion sur l&rsquo;export de fichier en XML avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour conclure, exporter une table SQL Server vers un fichier au format XML n&rsquo;est pas guid\u00e9 compl\u00e8tement car SSIS ne propose pas de composant natif pour l&rsquo;export XML. Cependant, avec du code T-SQL et les composants disponibles, il est possible d&rsquo;adapter la requ\u00eate \u00e0 la structure des donn\u00e9es et de configurer les composants avec le type de donn\u00e9es ad\u00e9quat.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Ressources utiles sur l&rsquo;export de donn\u00e9es avec SQL Server<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/exporter-table-sql-server-fichier-texte-ssis\/\">Exporter des donn\u00e9es SQL dans un fichier texte avec SSIS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/exporter-table-sql-server-fichier-excel-ssis\/\">Exporter une table SQL dans un fichier Excel avec SSIS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssms\/exporter-table-sql-server-vers-excel\/\">Export de donn\u00e9es SQL Server vers Excel avec SSMS<\/a><\/li>\n<\/ul>\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=\"dACoSq5Vcf\"><a href=\"https:\/\/expert-only.com\/fr\/tutoriels-ssis\/\">Tutoriels SSIS pour d\u00e9butants<\/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\u00a0Tutoriels SSIS pour d\u00e9butants\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/tutoriels-ssis\/embed\/#?secret=Z8w1T32a6o#?secret=dACoSq5Vcf\" data-secret=\"dACoSq5Vcf\" 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>Exporter les donn\u00e9es depuis une table SQL Server vers un fichier au format XML avec SSIS. Pour exporter une table SQL Server au dans un fichier de type XML avec un package SSIS et sans composant additionnel, il faut <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\" title=\"Exporter une table SQL Server dans un fichier XML avec SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10652,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-12857","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exporter une table SQL Server dans un fichier XML avec SSIS<\/title>\n<meta name=\"description\" content=\"Exporter les donn\u00e9es d&#039;une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.\" \/>\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-une-table-sql-en-xml-avec-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 dans un fichier XML avec SSIS\" \/>\n<meta property=\"og:description\" content=\"Exporter les donn\u00e9es d&#039;une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-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=\"2023-04-03T03:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-10T09:28:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_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-une-table-sql-en-xml-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Exporter une table SQL Server dans un fichier XML avec SSIS\",\"datePublished\":\"2023-04-03T03:36:00+00:00\",\"dateModified\":\"2023-05-10T09:28:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\"},\"wordCount\":929,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\",\"name\":\"Exporter une table SQL Server dans un fichier XML avec SSIS\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg\",\"datePublished\":\"2023-04-03T03:36:00+00:00\",\"dateModified\":\"2023-05-10T09:28:49+00:00\",\"description\":\"Exporter les donn\u00e9es d'une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-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 dans un fichier XML 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 dans un fichier XML avec SSIS","description":"Exporter les donn\u00e9es d'une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.","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-une-table-sql-en-xml-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Exporter une table SQL Server dans un fichier XML avec SSIS","og_description":"Exporter les donn\u00e9es d'une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-04-03T03:36:00+00:00","article_modified_time":"2023-05-10T09:28:49+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_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-une-table-sql-en-xml-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Exporter une table SQL Server dans un fichier XML avec SSIS","datePublished":"2023-04-03T03:36:00+00:00","dateModified":"2023-05-10T09:28:49+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/"},"wordCount":929,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/","name":"Exporter une table SQL Server dans un fichier XML avec SSIS","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg","datePublished":"2023-04-03T03:36:00+00:00","dateModified":"2023-05-10T09:28:49+00:00","description":"Exporter les donn\u00e9es d'une table SQL Server dans un fichier XML avec SSIS avec les fonctions XML natives et sans composant additionnel.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/fresh-glass-coffee-cup-2D256C64A99_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/exporter-une-table-sql-en-xml-avec-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 dans un fichier XML 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\/12857","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=12857"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/12857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10652"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=12857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=12857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=12857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}