{"id":14227,"date":"2024-01-15T06:22:00","date_gmt":"2024-01-15T05:22:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=14227"},"modified":"2024-02-26T13:24:37","modified_gmt":"2024-02-26T12:24:37","slug":"comment-pivoter-des-lignes-en-colonnes-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/","title":{"rendered":"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-transformer-les-donnees-d-une-table-sql-server-de-lignes-en-colonnes-dans-un-package-ssis-en-utilisant-la-transformation-pivot\"><em>Transformer les donn\u00e9es d&rsquo;une table SQL Server de lignes en colonnes dans un package SSIS en utilisant la transformation PIVOT.<\/em><\/h4>\n\n\n\n<p>La suite Microsoft BI permet nativement de pivoter des lignes en colonnes avec SSIS dans un flux de donn\u00e9es, depuis une table ou un fichier avec le composant Pivot. Mais comment r\u00e9aliser l&rsquo;op\u00e9ration en pratique avec un package? Voici donc un tutoriel pas \u00e0 pas pour param\u00e9trer le composant SSIS Pivot et transformer des donn\u00e9es depuis des lignes vers un format en colonnes. Dans notre exemple une colonne cible par mois de l&rsquo;ann\u00e9e.<\/p>\n\n\n\n<p>Cet exemple simple utilise une seule colonne non pivot\u00e9e car le composant ne permet pas de pivoter plus d&rsquo;une colonne sans utiliser l&rsquo;\u00e9diteur avanc\u00e9 et les num\u00e9ros de colonnes internes \u00e0 SSIS, appel\u00e9es LineageID. Le pivot de donn\u00e9es est couramment utilis\u00e9 dans <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Tableau_crois\u00e9_dynamique\" target=\"_blank\" rel=\"noreferrer noopener\">les tableaux<\/a> crois\u00e9s dynamiques 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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#1-creer-la-table-source-a-pivoter-depuis-ssis-premium\" >1. Cr\u00e9er la table source \u00e0 Pivoter depuis SSIS (Premium)<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#2-inserer-les-lignes-a-pivoter-avec-ssis-premium\" >2. Ins\u00e9rer les lignes \u00e0 Pivoter avec SSIS (Premium)<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#3-creer-la-table-cible-pour-les-donnees-pivotees-en-colonnes-premium\" >3. Cr\u00e9er la table cible pour les donn\u00e9es pivot\u00e9es en colonnes (Premium)<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#4-creer-un-flux-de-donnees-avec-le-pivot-ssis\" >4. Cr\u00e9er un flux de donn\u00e9es avec le Pivot SSIS<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#5-configurer-la-source-de-donnees-ssis-pour-le-pivot\" >5. Configurer la source de donn\u00e9es SSIS pour le Pivot<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#6-configurer-le-composant-ssis-pour-pivoter-les-lignes-en-colonnes\" >6. Configurer le composant SSIS pour pivoter les lignes en colonnes<\/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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#7-configurer-la-table-de-destination-avec-les-mois-en-colonnes\" >7. Configurer la table de destination avec les mois en colonnes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#8-executer-le-package-ssis-pour-pivoter-les-lignes\" >8. Ex\u00e9cuter le package SSIS pour Pivoter les lignes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#9-verifier-les-donnees-apres-le-pivot-depuis-ssms\" >9. V\u00e9rifier les donn\u00e9es apr\u00e8s le Pivot depuis SSMS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-creer-la-table-source-a-pivoter-depuis-ssis-premium\"><\/span>1. Cr\u00e9er la table source \u00e0 Pivoter depuis SSIS (Premium)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8re \u00e9tape : depuis SSMS, cr\u00e9er la table des ventes avec les valeurs mensuelles stock\u00e9es en lignes, il s&rsquo;agit d&rsquo;une instruction <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\"><strong>SQL Server Create Table de base avec une cl\u00e9 primaire<\/strong><\/a>.<\/p>\n\n\n\n<div class=\"wp-block-uagb-buttons uagb-buttons__outer-wrap uagb-btn__default-btn uagb-btn-tablet__default-btn uagb-btn-mobile__default-btn uagb-block-bb3f1488\"><div class=\"uagb-buttons__wrap uagb-buttons-layout-wrap\">\n<div class=\"wp-block-uagb-buttons-child uagb-buttons__outer-wrap uagb-block-a328f467 wp-block-button\"><div class=\"uagb-button__wrapper\"><a class=\"uagb-buttons-repeater wp-block-button__link\" aria-label=\"\" href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?couponCode=EO-SSIS-24-BEA561FDF\" rel=\"follow noopener\" target=\"_blank\"><span class=\"uagb-button__icon uagb-button__icon-position-before\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 448 512\"><path d=\"M438.6 278.6l-160 160C272.4 444.9 264.2 448 256 448s-16.38-3.125-22.62-9.375c-12.5-12.5-12.5-32.75 0-45.25L338.8 288H32C14.33 288 .0016 273.7 .0016 256S14.33 224 32 224h306.8l-105.4-105.4c-12.5-12.5-12.5-32.75 0-45.25s32.75-12.5 45.25 0l160 160C451.1 245.9 451.1 266.1 438.6 278.6z\"><\/path><\/svg><\/span><div class=\"uagb-button__link\"><strong><em>Contenu PREMIUM : Suivre la Formation SSIS en Vid\u00e9o<\/em><\/strong><\/div><\/a><\/div><\/div>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-inserer-les-lignes-a-pivoter-avec-ssis-premium\"><\/span>2. Ins\u00e9rer les lignes \u00e0 Pivoter avec SSIS (Premium)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ins\u00e9rer un jeu de donn\u00e9es pour remplir la table sur 2 ann\u00e9es.<\/p>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/learn\/lecture\/39820892?couponCode=EO-SSIS-24-BEA561FDF#overview\" target=\"_blank\" rel=\"noreferrer noopener\">Les ressources sont disponibles dans la formation SSIS.<\/a><\/em><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-creer-la-table-cible-pour-les-donnees-pivotees-en-colonnes-premium\"><\/span>3. Cr\u00e9er la table cible pour les donn\u00e9es pivot\u00e9es en colonnes (Premium)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cr\u00e9er enfin la table pour recevoir les donn\u00e9es apr\u00e8s le pivot qui contient chaque mois dans une colonne d\u00e9di\u00e9e.<\/p>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/learn\/lecture\/39820892?couponCode=EO-SSIS-24-BEA561FDF#overview\" target=\"_blank\" rel=\"noreferrer noopener\">Les ressources sont disponibles dans la formation SSIS.<\/a><\/em><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-creer-un-flux-de-donnees-avec-le-pivot-ssis\"><\/span>4. Cr\u00e9er un flux de donn\u00e9es avec le Pivot SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cette partie du tutoriel est la partie au c\u0153ur du sujet, car il s&rsquo;agit de param\u00e9trer le flux de donn\u00e9es. Au pr\u00e9alable, il faut bien s\u00fbr <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">cr\u00e9er un package dans un projet SSIS<\/a> et <a href=\"https:\/\/expert-only.com\/ssis\/creer-connexion-base-sql-server-ssis\/\">configurer une connexion \u00e0 une base SQL Server<\/a>. Ajouter ces 3 composants dans un flux de donn\u00e9es existant, ou en cr\u00e9er un nouveau.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Une connexion de type <strong><em>OLE DB Source<\/em><\/strong><\/li>\n\n\n\n<li>Une transformation <strong><em>Pivot<\/em><\/strong><\/li>\n\n\n\n<li>Une connexion de type <strong><em>OLE DB Destination<\/em><\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"480\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-1-add-pivot-and-sql-tables.jpg\" alt=\"Ajouter les composants OLE DB avec le Pivot SSIS pour transformer les lignes en colonnes\" class=\"wp-image-14246\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-1-add-pivot-and-sql-tables.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-1-add-pivot-and-sql-tables-300x240.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><em>Ajouter les composants OLE DB avec le Pivot SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-configurer-la-source-de-donnees-ssis-pour-le-pivot\"><\/span>5. Configurer la source de donn\u00e9es SSIS pour le Pivot<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>S\u00e9lectionner la table <strong><em>Sales_Monthly_In_Lines<\/em><\/strong> comme source du composant <em>OLE DB Source<\/em>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-2-select-sql-source-table.jpg\" alt=\"Choisir la table source avec les donn\u00e9es en lignes cr\u00e9\u00e9e \u00e0 la premi\u00e8re \u00e9tape\" class=\"wp-image-14254\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-2-select-sql-source-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-2-select-sql-source-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><em>Choisir la table source cr\u00e9\u00e9e \u00e0 la premi\u00e8re \u00e9tape<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-configurer-le-composant-ssis-pour-pivoter-les-lignes-en-colonnes\"><\/span>6. Configurer le composant SSIS pour pivoter les lignes en colonnes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Configurer maintenant le Pivot SSIS comme suit: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Choisir la clef de pivot dont les valeurs deviennent le nom des Nouvelles colonnes : <strong><em>MonthName<\/em><\/strong><\/li>\n\n\n\n<li>Choisir la colonne clef qui restera pr\u00e9sente en sortie : <strong><em>YearID<\/em><\/strong><\/li>\n\n\n\n<li>S\u00e9lectionner la colonne source qui contient les valeurs : <strong><em>SalesAmount<\/em><\/strong><\/li>\n\n\n\n<li>Entrer la liste des colonnes cr\u00e9\u00e9es par le Pivot, s\u00e9par\u00e9es par une virgule : <strong><em>01_Janvier \u00e0 12_D\u00e9cembre<\/em><\/strong><\/li>\n\n\n\n<li><strong><em>G\u00e9n\u00e9rer les colonnes<\/em><\/strong> pour remplir la zone de droite avec les nouvelles colonnes pivot\u00e9es.<\/li>\n<\/ol>\n\n\n\n<p>La liste des noms de colonnes est la suivante, sans espaces car le composant SSIS Pivot utilise les espaces dans les noms de colonnes g\u00e9n\u00e9r\u00e9s automatiquement.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">01_January,02_February,03_March,04_April,05_May,06_June,07_July,08_August,09_September,10_October,11_November,12_December <\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"552\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-3-setup-pivot-key-and-value.jpg\" alt=\"Configurer le Pivot SSIS pour transformer les lignes en colonnes\" class=\"wp-image-14263\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-3-setup-pivot-key-and-value.jpg 745w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-3-setup-pivot-key-and-value-300x222.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-3-setup-pivot-key-and-value-80x60.jpg 80w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><figcaption class=\"wp-element-caption\"><em>Configurer le Pivot SSIS pour transformer les lignes en colonnes<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Il n&rsquo;est possible de renseigner une seule colonne Clef pour pivoter les colonnes. Pour pivoter une table avec plus de colonnes de regroupement, utiliser l&rsquo;\u00e9diteur avanc\u00e9 et les identifiants de colonnes SSIS, ceci fera l&rsquo;objet d&rsquo;un autre tutoriel d\u00e9di\u00e9 au Pivot avec plusieurs colonnes fixes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-configurer-la-table-de-destination-avec-les-mois-en-colonnes\"><\/span>7. Configurer la table de destination avec les mois en colonnes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>S\u00e9lectionner la table de destination pour stocker dans la base SQL Server les donn\u00e9es apr\u00e8s le Pivot. C&rsquo;est la table <strong><em>dbo.Sales_Monthly_In_Columns<\/em><\/strong> cr\u00e9e \u00e0 l&rsquo;\u00e9tape 1.3 du tutoriel.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-5-select-sql-target-table.jpg\" alt=\"Choisir la table SQL pour stocker les donn\u00e9es apr\u00e8s le pivot SSIS\" class=\"wp-image-14287\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-5-select-sql-target-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-5-select-sql-target-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><em>Choisir la table SQL pour stocker les donn\u00e9es apr\u00e8s le pivot SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Depuis l&rsquo;onglet <em>Mappings<\/em>, relier chaque colonne source avec la colonne cible correspondante, soit les 12 colonnes g\u00e9n\u00e9r\u00e9es pour chaque mois de donn\u00e9es.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"743\" height=\"832\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-6-map-target-columns.jpg\" alt=\"Relier les colonnes pivot\u00e9es avec les colonnes dans la table SQL Server\" class=\"wp-image-14291\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-6-map-target-columns.jpg 743w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-6-map-target-columns-268x300.jpg 268w\" sizes=\"auto, (max-width: 743px) 100vw, 743px\" \/><figcaption class=\"wp-element-caption\"><em>Relier les colonnes pivot\u00e9es avec les colonnes dans la table SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Une fois tous les composants configur\u00e9s, Visual Studio n&rsquo;affiche aucune erreur ni avertissement, dans le cas contraire, v\u00e9rifier les liaisons et les type de donn\u00e9es. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-7-data-flow-without-warnings.jpg\" alt=\"Package SSIS avec le Pivot pour changer les lignes en colonnes\" class=\"wp-image-14301\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-7-data-flow-without-warnings.jpg 480w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-7-data-flow-without-warnings-300x288.jpg 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><figcaption class=\"wp-element-caption\"><em>Pivot SSIS pour transformer les lignes en colonnes<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-executer-le-package-ssis-pour-pivoter-les-lignes\"><\/span>8. Ex\u00e9cuter le package SSIS pour Pivoter les lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter maintenant le package pour transf\u00e9rer et pivoter les donn\u00e9es SQL Server du format en lignes vers un format en colonnes. Les 24 lignes du jeu de donn\u00e9es, soit 24 mois, sont pivot\u00e9es en seulement 2 lignes, soit 2 ann\u00e9es. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"480\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-8-execute-data-flow.jpg\" alt=\"Ex\u00e9cution du Pivot SSIS avec succ\u00e8s\" class=\"wp-image-14310\" style=\"width:600px;height:480px\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-8-execute-data-flow.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-8-execute-data-flow-300x240.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Ex\u00e9cution du Pivot SSIS avec succ\u00e8s<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9-verifier-les-donnees-apres-le-pivot-depuis-ssms\"><\/span>9. V\u00e9rifier les donn\u00e9es apr\u00e8s le Pivot depuis SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fois le package ex\u00e9cuter, se connecter \u00e0 la base de donn\u00e9es avec SSMS (<a href=\"https:\/\/expert-only.com\/ssms\/telecharger-sql-server-management-studio-18-ssms\/\">SQL Server Management Studio<\/a>) et ex\u00e9cuter ces 2 requ\u00eates de s\u00e9lection de donn\u00e9es. Le r\u00e9sultat est coh\u00e9rent avec pour la premi\u00e8re table les donn\u00e9es pour les ann\u00e9es 2021 et 2022 en ligne. Et pour la deuxi\u00e8me, les m\u00eames montants avec 2021 sur une seule ligne et l&rsquo;ann\u00e9e 2020 sur une autre ligne.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * from [dbo].[Sales_Monthly_In_Lines];\n\nselect * from [dbo].[Sales_Monthly_In_Columns];\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"880\" height=\"740\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-9-check-lines-and-columns-in-ssms.jpg\" alt=\"\" class=\"wp-image-14315\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-9-check-lines-and-columns-in-ssms.jpg 880w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-9-check-lines-and-columns-in-ssms-300x252.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-pivot-lines-to-columns-9-check-lines-and-columns-in-ssms-768x646.jpg 768w\" sizes=\"auto, (max-width: 880px) 100vw, 880px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Une mani\u00e8re simple de pivoter des lignes en colonnes avec SSIS<\/h3>\n\n\n\n<p>Pour conclure sur cet article qui explique comment pivoter les lignes en colonnes avec SSIS Pivot, le composant natif permet facilement de pivoter les lignes d&rsquo;une table SQL, mais cette derni\u00e8re doit avoir une structure simple. C&rsquo;est \u00e0 dire qu&rsquo;il g\u00e8re une seule colonne de regroupement, statique. Pour des cas plus complexes, il est recommand\u00e9 de passer par <strong><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/\">la requ\u00eate T-SQL PIVOT<\/a><\/strong> plus flexible et plus facile \u00e0 maintenir.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Tutoriels sur le Pivot ou Unpivot avec les technologies Microsoft<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/colonnes-en-lignes-avec-ssis\/\">Transformer les colonnes en lignes avec SSIS Unpivot<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/pivot-sql-server\/\">Pivoter une table avec une requ\u00eate SQL Server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/pivoter-tableau-excel\/\">Pivoter les lignes avec Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/requete-sql-server-unpivot\/\">Transposer les colonnes en lignes avec SQL UNPIVOT<\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"FcetrBgGmU\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\">Transformer les colonnes en lignes avec SSIS UNPIVOT<\/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\u00a0Transformer les colonnes en lignes avec SSIS UNPIVOT\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/embed\/#?secret=JC1gIMz4NL#?secret=FcetrBgGmU\" data-secret=\"FcetrBgGmU\" 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>Transformer les donn\u00e9es d&rsquo;une table SQL Server de lignes en colonnes dans un package SSIS en utilisant la transformation PIVOT. La suite Microsoft BI permet nativement de pivoter des lignes en colonnes avec SSIS dans un flux de donn\u00e9es, <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\" title=\"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10342,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-14227","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>Comment Pivoter Des Lignes En Colonnes Avec SSIS ? PIVOT<\/title>\n<meta name=\"description\" content=\"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.\" \/>\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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?\" \/>\n<meta property=\"og:description\" content=\"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-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=\"2024-01-15T05:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-26T12:24:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_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=\"6 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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?\",\"datePublished\":\"2024-01-15T05:22:00+00:00\",\"dateModified\":\"2024-02-26T12:24:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\"},\"wordCount\":1017,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\",\"name\":\"Comment Pivoter Des Lignes En Colonnes Avec SSIS ? PIVOT\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg\",\"datePublished\":\"2024-01-15T05:22:00+00:00\",\"dateModified\":\"2024-02-26T12:24:37+00:00\",\"description\":\"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Pivoter Des Lignes En Colonnes 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":"Comment Pivoter Des Lignes En Colonnes Avec SSIS ? PIVOT","description":"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.","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\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?","og_description":"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-01-15T05:22:00+00:00","article_modified_time":"2024-02-26T12:24:37+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment Pivoter Des Lignes En Colonnes Avec SSIS ?","datePublished":"2024-01-15T05:22:00+00:00","dateModified":"2024-02-26T12:24:37+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/"},"wordCount":1017,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/","name":"Comment Pivoter Des Lignes En Colonnes Avec SSIS ? PIVOT","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg","datePublished":"2024-01-15T05:22:00+00:00","dateModified":"2024-02-26T12:24:37+00:00","description":"D\u00e9velopper un package pour pivoter des lignes en colonnes avec SSIS et le composant de transformation Pivot dans un flux de donn\u00e9es.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/board-4874765_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/comment-pivoter-des-lignes-en-colonnes-avec-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment Pivoter Des Lignes En Colonnes 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\/14227","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=14227"}],"version-history":[{"count":16,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/14227\/revisions"}],"predecessor-version":[{"id":30057,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/14227\/revisions\/30057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10342"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=14227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=14227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=14227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}