{"id":738,"date":"2022-10-27T06:24:00","date_gmt":"2022-10-27T04:24:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=738"},"modified":"2023-01-04T16:45:40","modified_gmt":"2023-01-04T15:45:40","slug":"jointure-ssis-composant-merge-join","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/","title":{"rendered":"Jointure SSIS avec Merge Join"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Tutoriel pour faire une jointure SSIS avec deux tables SQL Server avec le composant Merge Join.<\/em><\/strong><\/h4>\n\n\n\n<p>Le composant SSIS Merge Join permet d&rsquo;effectuer une jointure pour fusionner deux ou plusieurs sources de donn\u00e9es \u00e0 partir d&rsquo;une clef commune. Autrement dit, le composant SSIS Merge Join permet de fusionner diff\u00e9rentes sources h\u00e9t\u00e9rog\u00e8nes ou non en une seule, par exemple des fichiers plats, des <a href=\"https:\/\/expert-only.com\/ssis\/importer-un-fichier-xml-avec-ssis\/\">documents XML<\/a>, des fichiers Excel ou encore des <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">tables SQL Server<\/a>.<\/p>\n\n\n\n<p>Ce tutoriel SSIS explique comment utiliser le composant SSIS qui permet de fusionner 2 tables sources SQL Server dans une seule table cible. Avec SSIS, que ce soit pour <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/integration-services\/lift-shift\/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">les versions on-premises ou sur Le Cloud Microsoft Azure<\/a>, le composant est utile pour g\u00e9rer des tables distinctes et sans utiliser de code T-SQL ou .NET. Merge Join en Anglais, il est appel\u00e9 <em><a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/integration-services\/data-flow\/transformations\/merge-join-transformation?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Jointure de fusion<\/a><\/em> en Fran\u00e7ais. <\/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\/jointure-ssis-composant-merge-join\/#1-preparer-les-tables-sources-et-la-table-cible-avec-ssms\" >1. Pr\u00e9parer les tables sources et la table cible avec SSMS<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#11-creer-la-table-source-des-ventes\" >1.1 Cr\u00e9er la table source des ventes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#12-creer-la-table-source-des-clients\" >1.2 Cr\u00e9er la table source des clients<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#13-creer-la-table-cible-des-ventes-enrichie\" >1.3 Cr\u00e9er la table cible des ventes enrichie<\/a><\/li><\/ul><\/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\/jointure-ssis-composant-merge-join\/#2-creer-un-flux-de-donnees-ssis-avec-merge-join\" >2. Cr\u00e9er un flux de donn\u00e9es SSIS avec Merge Join<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#21-preparer-les-composants-sources\" >2.1 Pr\u00e9parer les composants sources<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#22-parametrer-le-tri-des-donnees-sources\" >2.2 Param\u00e9trer le tri des donn\u00e9es sources<\/a><\/li><\/ul><\/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\/jointure-ssis-composant-merge-join\/#3-configurer-la-jointure-avec-merge-join-ssis\" >3. Configurer la jointure avec Merge Join SSIS<\/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\/jointure-ssis-composant-merge-join\/#4-preparer-la-table-cible-pour-stocker-le-resultat-de-la-jointure\" >4. Pr\u00e9parer la table cible pour stocker le r\u00e9sultat de la jointure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#5-executer-la-jointure-ssis-et-verifier-les-donnees-dans-la-table\" >5. Ex\u00e9cuter la jointure SSIS et v\u00e9rifier les donn\u00e9es dans la table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#conclusion-sur-le-composant-ssis-merge-join\" >Conclusion sur le composant SSIS Merge Join<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-preparer-les-tables-sources-et-la-table-cible-avec-ssms\"><span class=\"ez-toc-section\" id=\"1-preparer-les-tables-sources-et-la-table-cible-avec-ssms\"><\/span>1. Pr\u00e9parer les tables sources et la table cible avec SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Depuis SSMS, ex\u00e9cuter le code SQL ci-dessous pour cr\u00e9er deux tables sources \u00e0 fusionner dans une table cible. Les tables sources sont la table des table des ventes : <strong><em>dbo.Sales<\/em><\/strong> et la table des clients:<strong><em> dbo.Customers<\/em><\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-creer-la-table-source-des-ventes\"><\/span>1.1 Cr\u00e9er la table source des ventes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La premi\u00e8re table source est la table des ventes, elle sera enrichie dans un flux de donn\u00e9es SSIS avec les donn\u00e9es provenant de la table des clients, le pr\u00e9nom et le nom de famille.<\/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 ventes\nCREATE TABLE [dbo].[Sales](\n  [CustomerID]  [int] NOT NULL,\n  [MonthID]     [nvarchar](20) NOT NULL,\n  [YearID]      [nvarchar](20) NOT NULL,\n  [Qty]         [numeric](10,2) NOT NULL,\n  [Price]       [numeric](10,2) NOT NULL,\n  [Sales]       [numeric](10,2) NOT NULL,\n  [ProductID]   [int] NOT NULL,\n  [ProductName] [nvarchar](100) NOT NULL,\n  CONSTRAINT [SalesPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [MonthID], [YearID], [ProductID] ASC\n    )\n);\n\n-- Ins\u00e9rer les donn\u00e9es de ventes\nINSERT [dbo].[Sales] VALUES (1, N'1', N'2022', 10.00, 879.20, 8792.00, 31, N'Babka');\nINSERT [dbo].[Sales] VALUES (1, N'3', N'2021', 5.00, 312.00, 1560.00, 40, N'Unreal');\nINSERT [dbo].[Sales] VALUES (1, N'6', N'2021', 9.00, 627.00, 5643.00, 27, N'Qrunch');\nINSERT [dbo].[Sales] VALUES (1, N'7', N'2022', 6.00, 621.70, 3730.20, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (1, N'7', N'2022', 4.00, 653.10, 2612.40, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (1, N'9', N'2021', 2.00, 734.90, 1469.80, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (2, N'2', N'2021', 9.00, 895.60, 8060.40, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (2, N'3', N'2022', 11.00, 51.80, 569.80, 49, N'Menudito');\nINSERT [dbo].[Sales] VALUES (2, N'7', N'2021', 11.00, 112.20, 1234.20, 19, N'Chiavie');\nINSERT [dbo].[Sales] VALUES (2, N'9', N'2022', 7.00, 581.80, 4072.60, 33, N'Jans');\nINSERT [dbo].[Sales] VALUES (3, N'2', N'2022', 4.00, 576.60, 2306.40, 5, N'Amoy');\nINSERT [dbo].[Sales] VALUES (3, N'6', N'2021', 6.00, 551.10, 3306.60, 8, N'Gilda');\nINSERT [dbo].[Sales] VALUES (4, N'0', N'2021', 7.00, 15.40, 107.80, 26, N'Lasco');\nINSERT [dbo].[Sales] VALUES (4, N'1', N'2022', 2.00, 706.60, 1413.20, 27, N'Qrunch');\nINSERT [dbo].[Sales] VALUES (4, N'1', N'2022', 9.00, 491.70, 4425.30, 30, N'Paldo');\nINSERT [dbo].[Sales] VALUES (4, N'3', N'2022', 4.00, 810.20, 3240.80, 22, N'Bourbon');\nINSERT [dbo].[Sales] VALUES (4, N'4', N'2021', 9.00, 648.90, 5840.10, 42, N'Barbacoa');\nINSERT [dbo].[Sales] VALUES (4, N'5', N'2021', 7.00, 284.90, 1994.30, 5, N'Amoy');\nINSERT [dbo].[Sales] VALUES (5, N'11', N'2021', 3.00, 914.90, 2744.70, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (5, N'11', N'2022', 9.00, 903.80, 8134.20, 44, N'Kemps');\nINSERT [dbo].[Sales] VALUES (5, N'4', N'2022', 10.00, 133.90, 1339.00, 6, N'Haystack');\nINSERT [dbo].[Sales] VALUES (5, N'6', N'2021', 10.00, 940.20, 9402.00, 34, N'Amazin');\nINSERT [dbo].[Sales] VALUES (5, N'7', N'2021', 7.00, 352.90, 2470.30, 32, N'Maverik');\nINSERT [dbo].[Sales] VALUES (5, N'7', N'2022', 3.00, 116.40, 349.20, 7, N'Kalamata');\nINSERT [dbo].[Sales] VALUES (6, N'1', N'2021', 4.00, 283.30, 1133.20, 23, N'Oatsnack');\nINSERT [dbo].[Sales] VALUES (6, N'4', N'2021', 4.00, 604.90, 2419.60, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (6, N'4', N'2022', 5.00, 184.30, 921.50, 6, N'Haystack');\nINSERT [dbo].[Sales] VALUES (6, N'5', N'2022', 9.00, 464.40, 4179.60, 18, N'Lurpak');\nINSERT [dbo].[Sales] VALUES (6, N'8', N'2021', 6.00, 836.10, 5016.60, 40, N'Unreal');\nINSERT [dbo].[Sales] VALUES (6, N'9', N'2022', 4.00, 254.80, 1019.20, 1, N'Boncora');\nINSERT [dbo].[Sales] VALUES (7, N'0', N'2021', 7.00, 100.90, 706.30, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (7, N'10', N'2021', 4.00, 161.50, 646.00, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (7, N'10', N'2022', 7.00, 484.50, 3391.50, 50, N'Armanino');\nINSERT [dbo].[Sales] VALUES (7, N'3', N'2022', 7.00, 748.80, 5241.60, 38, N'Exo');\nINSERT [dbo].[Sales] VALUES (7, N'6', N'2021', 1.00, 623.50, 623.50, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (7, N'7', N'2021', 6.00, 185.00, 1110.00, 28, N'Basilico');\nINSERT [dbo].[Sales] VALUES (7, N'8', N'2022', 7.00, 625.50, 4378.50, 4, N'Sartori');\nINSERT [dbo].[Sales] VALUES (7, N'8', N'2022', 3.00, 125.40, 376.20, 38, N'Exo');\nINSERT [dbo].[Sales] VALUES (8, N'1', N'2021', 8.00, 949.80, 7598.40, 16, N'Homekist');\nINSERT [dbo].[Sales] VALUES (8, N'10', N'2021', 9.00, 944.30, 8498.70, 41, N'Baked');\nINSERT [dbo].[Sales] VALUES (8, N'10', N'2022', 7.00, 578.10, 4046.70, 2, N'Master');\nINSERT [dbo].[Sales] VALUES (8, N'12', N'2022', 3.00, 309.20, 927.60, 42, N'Barbacoa');\nINSERT [dbo].[Sales] VALUES (8, N'2', N'2022', 4.00, 417.80, 1671.20, 25, N'Scrapple');\nINSERT [dbo].[Sales] VALUES (8, N'4', N'2021', 7.00, 509.20, 3564.40, 4, N'Sartori');<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12-creer-la-table-source-des-clients\"><\/span>1.2 Cr\u00e9er la table source des clients<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La deuxi\u00e8me table source est celle des clients, qui permet de stocker le num\u00e9ro de client, le pr\u00e9nom, le nom de famille, la ville et le pays. Elle contient 8 lignes. <\/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 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<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"13-creer-la-table-cible-des-ventes-enrichie\"><\/span>1.3 Cr\u00e9er la table cible des ventes enrichie<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La table cible est une table des ventes enrichie avec le nom et le pr\u00e9nom des clients : <strong><em>dbo.SalesEnriched<\/em><\/strong>. La table enrichie a exactement la m\u00eame structure avec les deux colonnes suivantes en plus: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em>FirstName<\/em> : Pr\u00e9nom du client<\/li>\n\n\n\n<li><em>LastName<\/em> : Nom de famille du client<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[SalesEnriched](\n  [CustomerID]  [int] NOT NULL,\n  [MonthID]     [nvarchar](20) NOT NULL,\n  [YearID]      [nvarchar](20) NOT NULL,\n  [Qty]         [numeric](10,2) NOT NULL,\n  [Price]       [numeric](10,2) NOT NULL,\n  [Sales]       [numeric](10,2) NOT NULL,\n  [ProductID]   [int] NOT NULL,\n  [ProductName] [nvarchar](100) NOT NULL,\n  [FirstName]   [nvarchar](20) NULL,\n  [LastName]    [nvarchar](20) NULL,\n  CONSTRAINT [SalesSalesEnrichedPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [MonthID], [YearID], [ProductID] ASC\n    )\n);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-creer-un-flux-de-donnees-ssis-avec-merge-join\"><span class=\"ez-toc-section\" id=\"2-creer-un-flux-de-donnees-ssis-avec-merge-join\"><\/span>2. Cr\u00e9er un flux de donn\u00e9es SSIS avec Merge Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Au pr\u00e9alable, <a href=\"https:\/\/expert-only.com\/ssis\/creer-connexion-base-sql-server-ssis\/\">cr\u00e9er une connexion \u00e0 la base SQL Server<\/a> depuis le package SSIS. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-preparer-les-composants-sources\"><\/span>2.1 Pr\u00e9parer les composants sources<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Dans un flux de donn\u00e9es SSIS, ajouter les composants suivants, puis renommer les composants avec le nom des tables sources et cibles.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>2 composants OLE DB Source<\/li>\n\n\n\n<li>Un composant transformation Merge Join<\/li>\n\n\n\n<li>Une destination OLE DB<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-1-prepare-data-flow.jpg\" alt=\"Ajouter les composants SSIS OLE DB Source, Merge Join et la Destination OLE DB\" class=\"wp-image-15362\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-1-prepare-data-flow.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-1-prepare-data-flow-300x178.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Ajouter les composants SSIS OLE DB Source, Merge Join et la Destination OLE DB<\/figcaption><\/figure><\/div>\n\n\n<p>Choisir la premi\u00e8re table source de la jointure SSIS, c&rsquo;est \u00e0 dire la table gauche. <\/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\/11\/ssis-merge-join-2-select-left-source-table.jpg\" alt=\"S\u00e9lectionner la premi\u00e8re table source : Sales\" class=\"wp-image-15375\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-2-select-left-source-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-2-select-left-source-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lectionner la premi\u00e8re table source : Sales<\/figcaption><\/figure><\/div>\n\n\n<p>De la m\u00eame mani\u00e8re, s\u00e9lectionner la deuxi\u00e8me able source, la table des clients.<\/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\/11\/ssis-merge-join-3-select-right-source-table.jpg\" alt=\"Choisir la table \u00e0 droite de la jointure SSIS\" class=\"wp-image-15385\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-3-select-right-source-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-3-select-right-source-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Choisir la table \u00e0 droite de la jointure SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>Relier enfin les sources \u00e0 la transformation Merge Join SSIS, la fen\u00eatre apparait alors. Choisir l&rsquo;entr\u00e9e gauche pour la table dbo.Sales.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"265\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-4-select-input-as-left.jpg\" alt=\"Choisir l'entr\u00e9e de jointure SSIS gauche pour la table des ventes\" class=\"wp-image-15398\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-4-select-input-as-left.jpg 498w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-4-select-input-as-left-300x160.jpg 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><figcaption class=\"wp-element-caption\">Choisir l&rsquo;entr\u00e9e de jointure SSIS gauche pour la table des ventes<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22-parametrer-le-tri-des-donnees-sources\"><\/span>2.2 Param\u00e9trer le tri des donn\u00e9es sources<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Le package affiche une erreur SSIS: <\/p>\n\n\n\n<p><em>[Merge Join [2]] Error: \u00ab\u00a0Merge Join.Inputs[Merge Join Left Input]\u00a0\u00bb must be sorted. If possible, sort the data at the source and mark the data as sorted by setting the IsSorted and SortKeyPosition properties in the Advanced Editor. Otherwise, add a Sort Transformation to the path before the merge.<\/em><\/p>\n\n\n\n<p>Le message est assez explicite, il suffit donc de trier les colonnes de jointure \u00e0 l&rsquo;aide des 2 propri\u00e9t\u00e9s suivantes, depuis l&rsquo;\u00e9diteur avanc\u00e9 du composant.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em><strong>IsSorted<\/strong><\/em> : pour indiquer que la source est tri\u00e9e.<\/li>\n\n\n\n<li><em><strong>SortKeyPosition<\/strong><\/em> : pour indiquer l&rsquo;ordre des colonnes utilis\u00e9es pour le tri.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-text-align-center\"><strong><em>R\u00e9p\u00e9ter ces op\u00e9rations pour les deux tables sources.<\/em><\/strong><\/p>\n\n\n\n<p>Depuis les composants OLE DB Source:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Faire un <strong><em>clic-droit<\/em><\/strong><\/li>\n\n\n\n<li>Dans l&rsquo;onglet <em><strong>Input and Output Properties<\/strong><\/em><\/li>\n\n\n\n<li>S\u00e9lectionner <strong><em>OLE DB Source Output<\/em><\/strong><\/li>\n\n\n\n<li>Changer la propri\u00e9t\u00e9 <strong><em>IsSorted<\/em><\/strong> \u00e0 <strong>True<\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"622\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-5-issorted-property-true-1.jpg\" alt=\"Changer la valeur IsSorted dans l'\u00e9diteur avanc\u00e9 OLE DB\" class=\"wp-image-15412\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-5-issorted-property-true-1.jpg 711w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-5-issorted-property-true-1-300x262.jpg 300w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><figcaption class=\"wp-element-caption\">Changer la valeur IsSorted dans l&rsquo;\u00e9diteur avanc\u00e9 OLE DB<\/figcaption><\/figure><\/div>\n\n\n<p>Toujours depuis l&rsquo;\u00e9diteur avanc\u00e9 SSIS, s\u00e9lectionner cette fois la colonne utilis\u00e9e comme clef de jointure, ici c&rsquo;est <strong>CustomerID<\/strong>, et modifier la propri\u00e9t\u00e9 <strong><em>SortKeyPosition<\/em><\/strong> \u00e0 1. Dans une jointure avec des colonnes multiples, assigner les m\u00eames valeurs de tri aux colonnes correspondantes dans les 2 tables sources.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"622\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-6-change-sortkeyposition.jpg\" alt=\"Assigner SortKeyPosition \u00e0 1 pour la colonne CustomerID  \" class=\"wp-image-15425\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-6-change-sortkeyposition.jpg 711w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-6-change-sortkeyposition-300x262.jpg 300w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><figcaption class=\"wp-element-caption\">Assigner SortKeyPosition \u00e0 1 pour la colonne CustomerID  <\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-configurer-la-jointure-avec-merge-join-ssis\"><\/span>3. Configurer la jointure avec Merge Join SSIS  <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ouvrir le composant de transformation Merge Join et configurer les options comme suit: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Choisir le type de jointure SSIS: <strong><em>Left outer join<\/em><\/strong>.<\/li>\n\n\n\n<li>S\u00e9lectionner toutes les colonnes sources de la premi\u00e8re table.<\/li>\n\n\n\n<li>S\u00e9lectionner uniquement <strong><em>le pr\u00e9nom<\/em><\/strong> et <strong><em>le nom de famille<\/em><\/strong> de la deuxi\u00e8me table.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"772\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-7-configure-transformation.jpg\" alt=\"Configurer la jointure dans le composant SSIS Merge Join\" class=\"wp-image-15437\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-7-configure-transformation.jpg 660w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-7-configure-transformation-256x300.jpg 256w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><figcaption class=\"wp-element-caption\">Configurer la jointure dans le composant SSIS Merge Join<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-preparer-la-table-cible-pour-stocker-le-resultat-de-la-jointure\"><\/span>4. Pr\u00e9parer la table cible pour stocker le r\u00e9sultat de la jointure<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Configurer le dernier composant du flux de donn\u00e9es et le faire pointer sur la table des ventes enrichies.<\/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\/11\/ssis-merge-join-8-select-target-table.jpg\" alt=\"Choisir la table Sales_Enriched pour stocker le r\u00e9sultat de la jointure SSIS\" class=\"wp-image-15454\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-8-select-target-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-8-select-target-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Choisir la table Sales_Enriched pour stocker le r\u00e9sultat de la jointure SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier le mapping des colonnes depuis l&rsquo;onglet <em>Mappings<\/em>. Les colonnes provenant des 2 tables sources sont bien mapp\u00e9s vers la table cible. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"701\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-9-check-join-result-mappings.jpg\" alt=\"Mapping des donn\u00e9es issues de la jointure SSIS \u00e0 la table des ventes des ventes\" class=\"wp-image-15462\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-9-check-join-result-mappings.jpg 742w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-9-check-join-result-mappings-300x283.jpg 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><figcaption class=\"wp-element-caption\">Mapping des donn\u00e9es issues de la jointure SSIS \u00e0 la table des ventes des ventes<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-executer-la-jointure-ssis-et-verifier-les-donnees-dans-la-table\"><\/span>5. Ex\u00e9cuter la jointure SSIS et v\u00e9rifier les donn\u00e9es dans la table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter enfin le package SSIS, Les 44 lignes de donn\u00e9es de ventes sont bien int\u00e9gr\u00e9es dans la table enrichie sans erreur. Dans ce tutoriel simple, les lignes non enrichies ne sont pas g\u00e9r\u00e9es et donc non redirig\u00e9es.<\/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\/11\/ssis-merge-join-10-execute-transformation.jpg\" alt=\"44 lignes sont int\u00e9gr\u00e9es apr\u00e8s la jointure SSIS avec Merge Join\" class=\"wp-image-15473\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-10-execute-transformation.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-10-execute-transformation-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">44 lignes sont int\u00e9gr\u00e9es et enrichies<\/figcaption><\/figure><\/div>\n\n\n<p>Enfin cliquer sur Visualiser les donn\u00e9es depuis le composant OLE DB Destination pour lire la table et v\u00e9rifier que les deux colonnes sont bien enrichies avec les noms et pr\u00e9noms des clients.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"519\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-11-check-result-enriched-data-1.jpg\" alt=\"Les colonnes additionnelles sont bien enrichies par la jointure SSIS\" class=\"wp-image-15490\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-11-check-result-enriched-data-1.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/ssis-merge-join-11-check-result-enriched-data-1-300x243.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Les colonnes additionnelles sont bien enrichies par la jointure SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-sur-le-composant-ssis-merge-join\"><\/span>Conclusion sur le composant SSIS Merge Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La jointure SSIS permet de grouper les donn\u00e9es de deux tables sans \u00e9crire une seule ligne de code. Le seul pr\u00e9requis est de trier au pr\u00e9alable les donn\u00e9es, directement depuis l&rsquo;\u00e9diteur avanc\u00e9 ou avec le composant de tri.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Autres tutoriels sur les transformations SSIS<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/lignes-en-colonnes-avec-ssis-pivot\/\">Pivoter les lignes en colonnes avec SSIS Pivot<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/colonnes-en-lignes-avec-ssis\/\">Transformer les colonnes en lignes avec Unpivot<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/nombre-de-lignes-distinctes-avec-ssis\/\">Utiliser le composant d&rsquo;agr\u00e9gation pour compter les lignes distinctes<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/grouper-plusieurs-tables-avec-ssis-union-all\/\">Grouper les donn\u00e9es de plusieurs tables avec SSIS Union All<\/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\">\nhttps:\/\/expert-only.com\/ssis\/lignes-en-colonnes-avec-ssis-pivot\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutoriel pour faire une jointure SSIS avec deux tables SQL Server avec le composant Merge Join. Le composant SSIS Merge Join permet d&rsquo;effectuer une jointure pour fusionner deux ou plusieurs sources de donn\u00e9es \u00e0 partir d&rsquo;une clef commune. Autrement <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\" title=\"Jointure SSIS avec Merge Join\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10697,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[99],"class_list":{"0":"post-738","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>Jointure SSIS avec Merge Join - Integration Services - MS BI<\/title>\n<meta name=\"description\" content=\"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.\" \/>\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\/jointure-ssis-composant-merge-join\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jointure SSIS avec Merge Join\" \/>\n<meta property=\"og:description\" content=\"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\" \/>\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-10-27T04:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-04T15:45:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_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=\"11 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\/jointure-ssis-composant-merge-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Jointure SSIS avec Merge Join\",\"datePublished\":\"2022-10-27T04:24:00+00:00\",\"dateModified\":\"2023-01-04T15:45:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\"},\"wordCount\":1080,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg\",\"keywords\":[\"Fichier\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\",\"name\":\"Jointure SSIS avec Merge Join - Integration Services - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg\",\"datePublished\":\"2022-10-27T04:24:00+00:00\",\"dateModified\":\"2023-01-04T15:45:40+00:00\",\"description\":\"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jointure SSIS avec Merge Join\"}]},{\"@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":"Jointure SSIS avec Merge Join - Integration Services - MS BI","description":"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.","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\/jointure-ssis-composant-merge-join\/","og_locale":"fr_FR","og_type":"article","og_title":"Jointure SSIS avec Merge Join","og_description":"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-10-27T04:24:00+00:00","article_modified_time":"2023-01-04T15:45:40+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_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":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Jointure SSIS avec Merge Join","datePublished":"2022-10-27T04:24:00+00:00","dateModified":"2023-01-04T15:45:40+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/"},"wordCount":1080,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg","keywords":["Fichier"],"articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/","url":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/","name":"Jointure SSIS avec Merge Join - Integration Services - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg","datePublished":"2022-10-27T04:24:00+00:00","dateModified":"2023-01-04T15:45:40+00:00","description":"Faire une jointure avec le composant SSIS Merge Join pour fusionner deux sources de donn\u00e9es dans une seule table cible sans code SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/jointure-ssis-composant-merge-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Jointure SSIS avec Merge Join"}]},{"@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\/738","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=738"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10697"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}