{"id":20648,"date":"2022-10-27T06:24:00","date_gmt":"2022-10-27T04:24:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=20648"},"modified":"2023-01-04T17:58:43","modified_gmt":"2023-01-04T16:58:43","slug":"ssis-merge-join","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/","title":{"rendered":"SSIS Merge JOIN using multiple tables"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Tutorial to use the SSIS Merge Join transformation with two SQL Server tables into one target table.<\/em><\/strong><\/h4>\n\n\n\n<p>Use the Merge Join with the SSIS component allows you to perform a join and merge two or more data sources based on a common key. In other words, the SSIS Merge Join component allows you to merge different heterogeneous or non-heterogeneous sources into one, such as flat files, <a href=\"https:\/\/expert-only.com\/en\/ssis\/import-xml-file-into-a-table-with-ssis\/\">XML documents<\/a>, Excel files, or <a href=\"https:\/\/expert-only.com\/en\/manage-sql-server-tables\/\">SQL Server tables<\/a>.<\/p>\n\n\n\n<p>This SSIS tutorial explains how to use the SSIS component that merges two SQL Server source tables into one target table. With SSIS, whether for on-premises versions or on the Microsoft <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/integration-services\/lift-shift\/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Azure Cloud<\/a>, the component is useful for managing distinct tables without using T-SQL or .NET code.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#1-prepare-the-source-and-target-tables-to-join-with-ssms\" >1. Prepare the source and target tables to join with 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\/en\/ssis\/ssis-merge-join\/#11-create-the-sales-source-table\" >1.1 Create the sales source table<\/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\/en\/ssis\/ssis-merge-join\/#12-create-the-customers-source-table\" >1.2 Create the customers source table<\/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\/en\/ssis\/ssis-merge-join\/#13-create-the-enriched-sales-target-table\" >1.3 Create the enriched sales target table<\/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\/en\/ssis\/ssis-merge-join\/#2-create-an-ssis-data-flow-using-merge-join\" >2. Create an SSIS data flow using 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\/en\/ssis\/ssis-merge-join\/#21-prepare-the-source-components\" >2.1 Prepare the source components<\/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\/en\/ssis\/ssis-merge-join\/#22-configure-the-source-data-sorting\" >2.2 Configure the source data sorting<\/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\/en\/ssis\/ssis-merge-join\/#3-configure-the-ssis-merge-join-transformation\" >3. Configure the SSIS Merge Join transformation<\/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\/en\/ssis\/ssis-merge-join\/#4-prepare-the-target-table-to-store-the-ssis-merge-join-data\" >4. Prepare the target table to store the SSIS Merge Join data<\/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\/en\/ssis\/ssis-merge-join\/#5-run-the-ssis-merge-join-and-check-the-target-data\" >5. Run the SSIS Merge join and check the target data<\/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\/en\/ssis\/ssis-merge-join\/#6-conclusion-on-the-ssis-merge-join-component\" >6. Conclusion on the SSIS Merge Join component<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-prepare-the-source-and-target-tables-to-join-with-ssms\"><span class=\"ez-toc-section\" id=\"1-prepare-the-source-and-target-tables-to-join-with-ssms\"><\/span>1. Prepare the source and target tables to join with SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>From an SSMS tab, connect to the target database and run the following SQL code to create two source tables to <a href=\"https:\/\/brilliant.org\/wiki\/merge\/\" target=\"_blank\" rel=\"noreferrer noopener\">merge<\/a> into a target table. The source tables are: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The sales table: <strong><em>dbo.Sales<\/em><\/strong><\/li>\n\n\n\n<li>And the customers table: <strong><em>dbo.Customers<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-create-the-sales-source-table\"><\/span>1.1 Create the sales source table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The first source table is the sales table, it will be enriched in an SSIS data flow with data from the customers table, first and last name.<\/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=\"\">-- Create the Sales table\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-- Insert data into the Sales table\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-create-the-customers-source-table\"><\/span>1.2 Create the customers source table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The second source table is the customers table, which stores the customer number, first name, last name, city, and country. It contains 8 rows. <\/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=\"\">-- Create the Customers table\nCREATE TABLE [dbo].[Customers](\n   [CustomerID] [int] NOT NULL,\n   [FirstName] [nvarchar](20) NULL,\n   [LastName] [nvarchar](20) NULL,\n   [City] [nvarchar](20) NULL,\n   [Country] [nvarchar](50) NULL,\n   CONSTRAINT [CustomersPrimaryKeyCustomerID] PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO\n\n-- Insert 8 lines into the Customers table\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-create-the-enriched-sales-target-table\"><\/span>1.3 Create the enriched sales target table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The target table is an enriched sales table with the first and last names of customers: dbo.SalesEnriched. The enriched table has the same structure, but with the following two additional columns:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em><strong>FirstName<\/strong><\/em>: Customer&#8217;s first name<\/li>\n\n\n\n<li><em><strong>LastName<\/strong><\/em>: Customer&#8217;s last name<\/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-create-an-ssis-data-flow-using-merge-join\"><span class=\"ez-toc-section\" id=\"2-create-an-ssis-data-flow-using-merge-join\"><\/span>2. Create an SSIS data flow using Merge Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Prior to this, <a href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-sql-server-with-ssis\/\">create a connection to the SQL Server database<\/a> from the SSIS package. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-prepare-the-source-components\"><\/span>2.1 Prepare the source components<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In an SSIS data flow, add the following components, then rename the components with the names of the source and target tables.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>2 OLE DB Source components<\/li>\n\n\n\n<li>A Merge Join transformation component<\/li>\n\n\n\n<li>An OLE DB destination<\/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=\"Add SSIS OLE DB Source, Merge Join and OLE DB Destination components\" 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\">Add SSIS OLE DB Source, Merge Join and OLE DB Destination components<\/figcaption><\/figure><\/div>\n\n\n<p>Choose the first source table for the SSIS join, i.e., the left table. <\/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=\"Select the first source table which is the Sales one\" 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\">Select the first source table which is the Sales one<\/figcaption><\/figure><\/div>\n\n\n<p>In the same way, select the second source table, the customers table.<\/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=\"Choose the table to the right of the SSIS join\" 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\">Choose the table to the right of the SSIS join<\/figcaption><\/figure><\/div>\n\n\n<p>Finally, connect the sources to the SSIS Merge Join transformation, and the following window appears. Choose the left input for the <strong><em>dbo.Sales<\/em><\/strong> table.<\/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=\"Choose the left SSIS join entry for the sales table\" 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\">Choose the left SSIS join entry for the sales table<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22-configure-the-source-data-sorting\"><\/span>2.2 Configure the source data sorting<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The package displays an SSIS error: <\/p>\n\n\n\n<p><em>[Merge Join [2]] Error: &#8220;Merge Join.Inputs[Merge Join Left Input]&#8221; 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>The message is quite explicit, so just sort the join columns using the following 2 properties, from the component&#8217;s advanced editor.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em><strong>IsSorted<\/strong><\/em>: to indicate that the source is sorted.<\/li>\n\n\n\n<li><em><strong>SortKeyPosition<\/strong><\/em>: to indicate the order of the columns used for sorting.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-text-align-center\"><strong><em><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">Repeat these operations for both source tables.<\/mark><\/em><\/strong><\/p>\n\n\n\n<p>From the OLE DB Source components:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Right-click<\/li>\n\n\n\n<li>In the <em><strong>Input and Output Properties<\/strong><\/em> tab<\/li>\n\n\n\n<li>Select <strong><em>OLE DB Source Output<\/em><\/strong><\/li>\n\n\n\n<li>Change the <strong><em>IsSorted<\/em><\/strong> property to <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=\"Change the value of IsSorted in the advanced OLE DB editor\" 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\">Change the value of IsSorted in the advanced OLE DB editor<\/figcaption><\/figure><\/div>\n\n\n<p>Still in the advanced SSIS editor, select this time the column used as the join key, here it is <strong>CustomerID<\/strong>, and modify the <strong><em>SortKeyPosition<\/em><\/strong> property to 1. In a join with multiple columns, assign the same sort values to the corresponding columns in the two source tables.<\/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=\"Assign the SortKeyPosition to 1 for the CustomerID column\" 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\">Assign the SortKeyPosition to 1 for the CustomerID column<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-configure-the-ssis-merge-join-transformation\"><\/span>3. Configure the SSIS Merge Join transformation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Open the Merge Join transformation component and configure the options as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Choose the type of SSIS join: <strong><em>Left outer join<\/em><\/strong>.<\/li>\n\n\n\n<li>Select all columns from the first table.<\/li>\n\n\n\n<li>Select only <strong><em>first name<\/em><\/strong> and <strong><em>last name<\/em><\/strong> from the second 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=\"Configure the join in the SSIS Merge Join component\" 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\">Configure the join in the SSIS Merge Join component<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-prepare-the-target-table-to-store-the-ssis-merge-join-data\"><\/span>4. Prepare the target table to store the SSIS Merge Join data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Configure the last component of the data flow and point it to the enriched sales table.<\/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=\"Select the Sales_Enriched table to store the result of the SSIS join\" 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\">Select the Sales_Enriched table to store the result of the SSIS join<\/figcaption><\/figure><\/div>\n\n\n<p>Verify column mapping from the Mappings tab. Columns from both source tables are properly mapped to the target table.<\/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=\"Map the columns from the SSIS join to the sales enriched table\" 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\">Map the columns from the SSIS join to the sales enriched table<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-run-the-ssis-merge-join-and-check-the-target-data\"><\/span>5. Run the SSIS Merge join and check the target data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, run the SSIS package. The 44 sales data rows are successfully integrated into the enriched table with no errors. In this simple tutorial, unenriched rows are not handled and therefore not redirected.<\/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 rows are merged and enriched by the SSIS Merge Join transformation\" 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 rows are merged and enriched by the SSIS Merge Join transformation<\/figcaption><\/figure><\/div>\n\n\n<p>Finally, click on View Data from the OLE DB Destination component to read the table and verify that the two columns are enriched with the names and first names of the 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=\"The 2 additional columns enriched by the SSIS Merge Join\" 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\">The 2 additional columns enriched by the SSIS Merge Join<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-conclusion-on-the-ssis-merge-join-component\"><\/span>6. Conclusion on the SSIS Merge Join component<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The SSIS join allows you to group data from two tables without writing a single line of code. The only prerequisite is to sort the data beforehand, directly from the advanced editor or using the SSIS Sort Transformation.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Other tutorials on SQL Server and SSIS transformations<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-pivot-query-example\/\">Pivot rows into columns with SQL Server Pivot<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-unpivot\/\">Transform columns into rows with Unpivot<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/aggregate-data-with-ssis\/\">Use the aggregation component to count distinct rows<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partition\/\">Create SQL Server table partitions with T-SQL code<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutorial to use the SSIS Merge Join transformation with two SQL Server tables into one target table. Use the Merge Join with the SSIS component allows you to perform a join and merge two or more data sources based <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\" title=\"SSIS Merge JOIN using multiple tables\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[417],"class_list":{"0":"post-20648","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis","8":"tag-file"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SSIS Merge Join - Integration Services - MS BI<\/title>\n<meta name=\"description\" content=\"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSIS Merge JOIN using multiple tables\" \/>\n<meta property=\"og:description\" content=\"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-27T04:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-04T16:58:43+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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"SSIS Merge JOIN using multiple tables\",\"datePublished\":\"2022-10-27T04:24:00+00:00\",\"dateModified\":\"2023-01-04T16:58:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\"},\"wordCount\":939,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg\",\"keywords\":[\"File\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\",\"name\":\"SSIS Merge Join - Integration Services - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-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-04T16:58:43+00:00\",\"description\":\"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/ssis-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\/en\/ssis\/ssis-merge-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Merge JOIN using multiple tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SSIS Merge Join - Integration Services - MS BI","description":"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Merge JOIN using multiple tables","og_description":"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.","og_url":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-10-27T04:24:00+00:00","article_modified_time":"2023-01-04T16:58:43+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":{"Written by":"Expert-Only","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"SSIS Merge JOIN using multiple tables","datePublished":"2022-10-27T04:24:00+00:00","dateModified":"2023-01-04T16:58:43+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/"},"wordCount":939,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-45DA743585A_1920x1080.jpg","keywords":["File"],"articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/","url":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/","name":"SSIS Merge Join - Integration Services - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-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-04T16:58:43+00:00","description":"Step by step tutorial on the SSIS Merge Join component to merge two data sources into one or more target tables without writing T-SQL code.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/ssis-merge-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/ssis-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\/en\/ssis\/ssis-merge-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"SSIS Merge JOIN using multiple tables"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/20648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=20648"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/20648\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10699"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=20648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=20648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=20648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}