{"id":11477,"date":"2022-08-30T06:57:00","date_gmt":"2022-08-30T04:57:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=11477"},"modified":"2022-10-04T17:54:49","modified_gmt":"2022-10-04T15:54:49","slug":"create-a-simple-ssis-data-flow","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/","title":{"rendered":"Create a simple SSIS data flow"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-how-to-create-a-simple-data-flow-with-ssis-and-visual-studio-2019\"><strong><em>How to create a simple data flow with SSIS and Visual Studio 2019?<\/em><\/strong><\/h4>\n\n\n\n<p>This tutorial explains how to create a basic SSIS data flow and serves as an example to get started with a first data manipulation. That is to say to configure a package to extract, transform if necessary and finally load the data in another <a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/create-database-ssms\/\">MS database<\/a> or another <a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\">SQL table<\/a>. A data flow allows for example to copy data from a local MS SQL database to a flat file or vice versa. Or more generally from a data source to a target.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a basic SSIS data flow to transfer data between two tables<\/h2>\n\n\n\n<p>SSIS is the ETL brick of the SQL Server BI suite, i.e. Microsoft SSIS packages are used to integrate and <a href=\"https:\/\/www.talend.com\/resources\/etl-architecture\/\" target=\"_blank\" rel=\"noreferrer noopener\">process data<\/a>. In an SSIS package, the basic elements are control flows and data flows. In addition, data integration software suites are at the heart of data warehouse development projects.<\/p>\n\n\n\n<p>An SSIS package is structured as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>SSIS package<\/strong> (Package.dtsx for example)<ul><li><strong>Control Flow<\/strong><ul><li><strong>Data Flow<\/strong><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p>This means that an SSIS package contains one or more control flows, and the control flows themselves contain one or more data flows.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Prerequisite for the tutorial is to install Visual Studio 2019 and SSIS projects<\/h4>\n\n\n\n<p>Before starting this tutorial:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Start by <a href=\"https:\/\/expert-only.com\/en\/ssis\/install-ssis-in-visual-studio-2019\/\">installing Visual Studio 2019 and the SSIS projects extension<\/a>.<\/li><li>Then <a href=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/\">create an SSIS project<\/a>.<\/li><li><a href=\"https:\/\/expert-only.com\/en\/ssis\/create-a-connection-to-sql-server-database-in-ssis\/\">Create a connection to the SQL Server database with SSIS<\/a>, using the Connection Managers.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">1. Add the data stream to the control flow and create the source table<\/h3>\n\n\n\n<p>To begin, from the Visual Studio 2019 window, drag the Data Flow Task component onto the workspace in the Control Flow tab. Or double-click on the component from the SSIS Toolbox. Then double-click it to edit it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"685\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg\" alt=\"Create the data flow task into the control flow within the SSIS package\" class=\"wp-image-11381\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg 729w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow-300x282.jpg 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><figcaption>Create the data flow task into the control flow within the SSIS package<\/figcaption><\/figure><\/div>\n\n\n<p>This tutorial uses this table, created in this tutorial on creating MS SQL tables with a primary key. The code for creating the source table is available below. To create the table and insert the data, connect to the database with SSMS.<\/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 source 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-- Insert 4 different lines\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 1, 'Ali','Ahmed','Cairo','Egypt');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 2, 'Johnny','John','Toronto','Canada');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 3, 'John','Doe','Mexico City','Mexico');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 4, 'Shu','Abbas','Paris','France');\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. Configure the OLE DB data source<\/h3>\n\n\n\n<p>The cursor is now on the Data Flow tab. From this tab, select the OLE DB Source tool and drag it onto the workspace.<\/p>\n\n\n\n<p>Double click on the component. From the OLE DB Source editor menu, select the Connection Manager tab. Then select the database and source table for our data stream.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"805\" height=\"693\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview.jpg\" alt=\"Configure the source table with the OLE DB editor inside the SSIS data flow\" class=\"wp-image-11389\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview.jpg 805w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview-300x258.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview-768x661.jpg 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><figcaption>Configure the source table with the OLE DB editor inside the SSIS data flow<\/figcaption><\/figure><\/div>\n\n\n<p>Then go to the Columns tab and check that the columns of the table are present. Finally select those whose content is to be exported. Perform the mapping according to the column names. By default, the output columns have the same name as the columns in the source table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"622\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings.jpg\" alt=\"Check the column mapping from the Columns tab\" class=\"wp-image-11396\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings.jpg 742w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings-300x251.jpg 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><figcaption>Check the column mapping from the Columns tab<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">3. Create a derived SSIS column<\/h3>\n\n\n\n<p>Create a transformation with the SSIS Derived Column component. Add it to the data stream, link it to the OLE DB Source tool and double click to open the component.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"589\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow.jpg\" alt=\"Add then link the OLE DB Source to the SSIS Derived Column component and edit it  \" class=\"wp-image-11405\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow.jpg 537w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow-274x300.jpg 274w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><figcaption>Add then link the OLE DB Source to the SSIS Derived Column component and edit it  <\/figcaption><\/figure><\/div>\n\n\n<p>Editing the data is done in the Derived Column Transformation Editor menu. Insert a column or make changes using the various SSIS functions from the right-hand window.<\/p>\n\n\n\n<p>Here the aim is to transform the surname and first name into a target column with the initials of each customer. Follow the steps below:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create a new column called Initials.<\/li><li>Choose add as a new column so as not to replace an existing column.<\/li><li>Then fill in the formula<\/li><li>Here the choice is to add a new column, with a length of 8 characters.<\/li><\/ul>\n\n\n\n<p>The formula used in the package retrieves the first letter of the first name, then concatenates the result with the first letter of the last name and finally forces the type with a length of 8 characters.<\/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=\"\">(DT_WSTR,8)(LEFT(FirstName,1) + LEFT(LastName,1))<\/pre>\n\n\n\n<p><strong>The equivalent of the SQL Server NVARCHAR data type is the SSIS DT_WSTR type.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"632\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials.jpg\" alt=\"Add to edit the Initials derived column based on the First and last name\" class=\"wp-image-11414\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials.jpg 831w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-300x228.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-768x584.jpg 768w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-80x60.jpg 80w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><figcaption>Add to edit the Initials derived column based on the First and last name<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">4. Add the OLE DB destination to the data flow and create the target table<\/h3>\n\n\n\n<p>To store the modified data, start by <a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\">creating the target table<\/a> with the following SQL code. This is <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-alter-table\/\">the same table structure with an extra column<\/a> to hold the initials.<\/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 TABLE [dbo].[Customers_with_initials](\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   [Initials] [nvarchar](8) NULL,\n   CONSTRAINT [CustomersInitialsPKCustomerID] PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO<\/pre>\n\n\n\n<p>Then select the OLE DB Destination component and drag it onto the workspace in the data stream. Then link the Derived Column tool to it. Finally, double click on it to edit it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"578\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column.jpg\" alt=\"\" class=\"wp-image-11429\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column.jpg 540w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column-280x300.jpg 280w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><figcaption>Add the OLE DB destination to the SSIS package<\/figcaption><\/figure><\/div>\n\n\n<p>Open the OLE DB Destination Editor menu. In the connection manager tab, choose the destination table for the load.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"635\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table.jpg\" alt=\"Configure the destination table to contain the data in the SSIS data flow\" class=\"wp-image-11423\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table.jpg 751w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table-300x254.jpg 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><figcaption>Configure the destination table to contain the data in the SSIS data flow<\/figcaption><\/figure><\/div>\n\n\n<p>Then in the Mappings tab, check that the columns are linked correctly. By default, the Integration Services package editor automatically links columns with the same name.<\/p>\n\n\n\n<p><strong>It is good SSIS practice to rename columns upstream to facilitate data mapping.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"635\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually.jpg\" alt=\"\" class=\"wp-image-11434\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually.jpg 751w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually-300x254.jpg 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><figcaption>Map columns by hand if necessary with SSIS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">5. Run the SSIS package and check the results with SSMS<\/h3>\n\n\n\n<p>Now, to start loading, you need to run the package from Visual Studio. To do this, click on the Start button or directly with the F5 shortcut.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019.jpg\" alt=\"Run the SSIS package and check the data flow results\" class=\"wp-image-11443\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019.jpg 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019-300x257.jpg 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption>Run the SSIS package and check the data flow results<\/figcaption><\/figure><\/div>\n\n\n<p>To check the data in both tables, simply run these selection queries from SSMS:<\/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].[Customers];\nselect * from [dbo].[Customers_with_initials];<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"400\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query.jpg\" alt=\"Query from SSMS with the two tables and the initials created by the SSIS package\" class=\"wp-image-11484\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query.jpg 730w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query-300x164.jpg 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><figcaption>Query from SSMS with the two tables and the initials created by the SSIS package<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Video tutorial to create a simple data flow with SSIS<\/h2>\n\n\n\n<p>The video tutorial shows all the steps to load data from a source table to a target one and how to populate the Initials additional column with data from the existing columns.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to create an SSIS Data Flow using Visual Studio 2019 ?\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/vWoHeRVRFdE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>So here is how to create a basic SSIS data flow to copy data from one table to another and add a column derived from two existing columns. To take data manipulation with SSIS a step further, here&#8217;s <a href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\">how to detect and manage data types from an Excel source file<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-expert-only wp-block-embed-expert-only\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"DgivOz9WXt\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\">Manage Excel data type with SSIS before integration<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Manage Excel data type with SSIS before integration&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/embed\/#?secret=GfkrE8mE0U#?secret=DgivOz9WXt\" data-secret=\"DgivOz9WXt\" 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>How to create a simple data flow with SSIS and Visual Studio 2019? This tutorial explains how to create a basic SSIS data flow and serves as an example to get started with a first data manipulation. That is <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\" title=\"Create a simple SSIS data flow\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5991,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[],"class_list":{"0":"post-11477","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>Create a simple SSIS data flow - Integration Services<\/title>\n<meta name=\"description\" content=\"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.\" \/>\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\/create-a-simple-ssis-data-flow\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create a simple SSIS data flow\" \/>\n<meta property=\"og:description\" content=\"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\" \/>\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-08-30T04:57:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:54:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg\" \/>\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=\"8 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\/create-a-simple-ssis-data-flow\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Create a simple SSIS data flow\",\"datePublished\":\"2022-08-30T04:57:00+00:00\",\"dateModified\":\"2022-10-04T15:54:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\"},\"wordCount\":1032,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\",\"name\":\"Create a simple SSIS data flow - Integration Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg\",\"datePublished\":\"2022-08-30T04:57:00+00:00\",\"dateModified\":\"2022-10-04T15:54:49+00:00\",\"description\":\"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create a simple SSIS data flow\"}]},{\"@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":"Create a simple SSIS data flow - Integration Services","description":"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.","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\/create-a-simple-ssis-data-flow\/","og_locale":"en_US","og_type":"article","og_title":"Create a simple SSIS data flow","og_description":"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.","og_url":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-08-30T04:57:00+00:00","article_modified_time":"2022-10-04T15:54:49+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg","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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Create a simple SSIS data flow","datePublished":"2022-08-30T04:57:00+00:00","dateModified":"2022-10-04T15:54:49+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/"},"wordCount":1032,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg","articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/","url":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/","name":"Create a simple SSIS data flow - Integration Services","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg","datePublished":"2022-08-30T04:57:00+00:00","dateModified":"2022-10-04T15:54:49+00:00","description":"Tutorial to create a SSIS Data Flow in a package and transfer data between two SQL Server tables with a basic data flow.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/gears-14583399EA5_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Create a simple SSIS data flow"}]},{"@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\/11477","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=11477"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/11477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5991"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=11477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=11477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=11477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}