{"id":36,"date":"2015-08-28T22:27:38","date_gmt":"2015-08-28T22:27:38","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=36"},"modified":"2025-10-01T21:54:14","modified_gmt":"2025-10-01T21:54:14","slug":"ssis-dataflow-expression-source-component-property","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/","title":{"rendered":"How to set SSIS Data Flow component property using expression and variable"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a> supports various methods for making things dynamic. Sometimes you have to consume JSON Data from a Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic.<\/p>\n<ul>\n<li>Use Expression on the DirectPath property of the JSON Source (SSIS Data Flow Expression)<\/li>\n<li>Use variable placeholders directly inside URL (Only works when you use DirectPath mode)<\/li>\n<li>Use PathFromvariable AccessMode and define an expression on an SSIS variable<\/li>\n<\/ul>\n<h2>Use SSIS Data Flow Expression<\/h2>\n<p>So you change any property of the SSIS Data Flow component at runtime using an expression:<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-2159\"><ol style=\"margin-left: 0;\">\r\n \t<li>To define an expression for any property of a component, first navigate to the Data Flow designer surface.<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Change-Component-Property-at-runtime.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11511 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Change-Component-Property-at-runtime.png\" alt=\"SSIS DataFlow Expression - Change Component Property at runtime\" width=\"370\" height=\"374\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Change-Component-Property-at-runtime.png 370w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Change-Component-Property-at-runtime-297x300.png 297w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/a><\/li>\r\n \t<li>Now, right-click anywhere in the data flow designer surface and click the \"Properties\" menu item.<\/li>\r\n \t<li>When the Properties window appears, select a property and press the [...] button to set an expression.<\/li>\r\n \t<li>Now enter the property and expression you need.<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Edit-Component-Property-Expression.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11512 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Edit-Component-Property-Expression.png\" alt=\"SSIS DataFlow Expression - Edit Component Property Expression\" width=\"920\" height=\"515\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Edit-Component-Property-Expression.png 920w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Edit-Component-Property-Expression-300x168.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/SSIS-DataFlow-Expression-Edit-Component-Property-Expression-768x430.png 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/a><\/li>\r\n<\/ol><\/div>\n<h2>Use Variable Placeholders<\/h2>\n<p><a href=\"\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a> supports Variable Placeholders for easy editing and making values dynamic. Variable placeholders are directly visible, unlike expressions, which are hidden. See the screenshot below for an example of how to type a variable placeholder, which gets replaced by the actual value of the SSIS variable at runtime.<\/p>\n<div id=\"attachment_11516\" style=\"width: 838px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11516\" class=\"size-full wp-image-11516\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\" alt=\"\" width=\"828\" height=\"745\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png 828w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders-300x270.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders-768x691.png 768w\" sizes=\"(max-width: 828px) 100vw, 828px\" \/><\/a><p id=\"caption-attachment-11516\" class=\"wp-caption-text\">SSIS dataflow Expression alternative &#8211; Using Variable Placeholders<\/p><\/div>\n<h2>PathFromVariable mode and Use Expression on Variable<\/h2>\n<p>If you choose a path from a variable, then you can define an Expression on the variable to make your path dynamic at runtime.<\/p>\n<h2>Making Task Property Dynamic using SSIS Expression<\/h2>\n<p>Check <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/4787452038171\" target=\"_blank\" rel=\"noopener\">this article<\/a> if you want to make the Task Property dynamic<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction SSIS PowerPack supports various methods for making things dynamic. Sometimes you have to consume JSON Data from a Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic. Use Expression on the DirectPath property of the JSON Source (SSIS Data Flow Expression) Use variable placeholders directly inside URL (Only works [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11516,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[19,6,12],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to set SSIS Data Flow component property using expression and variable | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to set SSIS Data Flow component property using expression and variable | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2015-08-28T22:27:38+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-01T21:54:14+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"828\" \/>\r\n\t<meta property=\"og:image:height\" content=\"745\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/\",\"name\":\"How to set SSIS Data Flow component property using expression and variable | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\",\"datePublished\":\"2015-08-28T22:27:38+00:00\",\"dateModified\":\"2025-10-01T21:54:14+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png\",\"width\":828,\"height\":745,\"caption\":\"SSIS dataflow Expression alternative - Using Variable Placeholders\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set SSIS Data Flow component property using expression and variable\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to set SSIS Data Flow component property using expression and variable | ZappySys Blog","description":"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.","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:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/","og_locale":"en_US","og_type":"article","og_title":"How to set SSIS Data Flow component property using expression and variable | ZappySys Blog","og_description":"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.","og_url":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2015-08-28T22:27:38+00:00","article_modified_time":"2025-10-01T21:54:14+00:00","og_image":[{"width":828,"height":745,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/","url":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/","name":"How to set SSIS Data Flow component property using expression and variable | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png","datePublished":"2015-08-28T22:27:38+00:00","dateModified":"2025-10-01T21:54:14+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"In this post you will learn about SSIS Data Flow Expression and variable placeholder to make Data Flow Component Property dynamic. ZappySys components supports placeholders.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/SSIS-dataflow-Expression-alternative-Using-Variable-Placeholders.png","width":828,"height":745,"caption":"SSIS dataflow Expression alternative - Using Variable Placeholders"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-dataflow-expression-source-component-property\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to set SSIS Data Flow component property using expression and variable"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/36"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=36"}],"version-history":[{"count":8,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/36\/revisions"}],"predecessor-version":[{"id":11517,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/36\/revisions\/11517"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11516"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}