{"id":10637,"date":"2023-10-19T22:21:16","date_gmt":"2023-10-19T22:21:16","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=10637"},"modified":"2023-10-19T22:21:16","modified_gmt":"2023-10-19T22:21:16","slug":"examples-with-validator-task","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/","title":{"rendered":"Examples with Validator task"},"content":{"rendered":"

Introduction<\/h2>\n

In SQL Server Integration Services (SSIS), validating expressions, paths, and URLs is a crucial part of ensuring the integrity and success of your data integration processes. In this article, we’ll explore how the Validator Task can help you achieve this.<\/p>\n

Before we dive into practical examples, be sure to check our comprehensive Validator Task article to discover the full range of options it offers. You can access it here<\/a>.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    Validating an Example<\/h2>\n

    Let’s start by validating an example stored in a variable. You can source your example data from a variety of components, such as the Set Variable Transformation (see our article here<\/a>) or the REST API Task (read more here<\/a>). Once you have the example data in a variable, the Validator Task comes into play. You can configure the necessary expressions, as demonstrated in this example.<\/p>\n

    <\/div>\n
    \"Validator<\/a>

    Configurate the validator task to compare two string.<\/p><\/div>\n

    Validating a File or a Folder<\/h2>\n

    In some cases, you may need to validate a path, which might involve checking file or folder properties, such as their existence or size. Our advanced File System Task or SFTP Task can help you accomplish this. In our example, we’ll show you how to count the number of files in a folder and trigger a pass condition when there are more than five files.:<\/p>\n

    \"\"<\/a>

    We employ a wildcard to retrieve all TXT files from the folder and store the result in a variable called “count.”<\/p><\/div>\n

    Validate the result: Next, we’ll drag and drop the Validator Task and select “Check SSIS expression (true or false).” We’ll use the expression @[User::count]==3 to validate whether we have 3 files in that folder. We’ll set the expected result as true, and we’ll also check the option to save the validator status to a variable and throw an error if the validator fails to terminate the package.<\/p>\n

    \"\"<\/a>

    You can validate the expressions with the result you want (true\/false)<\/p><\/div>\n

    You will receive a valid example, and the package will run successfully, or it will fail, as shown in this example:<\/p>\n

    \"Validator<\/a>

    Example from success and a failure example<\/p><\/div>\n

    You can use more examples, such as checking if a file exists or verifying the existence of a folder using the Advanced File System, Validator Task or other components.<\/p>\n

    \"\"<\/a>

    Some examples for advanced file system task and Secure FTP task<\/p><\/div>\n

    Validating a URL<\/h2>\n

    There are scenarios where the success of a URL is critical. If a URL fails, you may want your SSIS process to stop. Here’s an example of how to set up a REST API Task to handle errors, save the result in a variable, and use the Validator Task to mark a URL as invalid in case of failure.<\/p>\n

    \"Rest<\/a>

    Use this option to continue on any error and save the result in a Boolean variable<\/p><\/div>\n

    Now for validator task we set up the next configuration:<\/p>\n

    \"Validator<\/a>

    Validate if the URL is valid<\/p><\/div>\n

    The last step is running the package. Here you will see the two cases.<\/p>\n

    \"Validator<\/a>

    Comparing both results if the URL is valid or not<\/p><\/div>\n

    Conclusion<\/h2>\n

    In conclusion, the Validator Task in SSIS empowers you to dynamically choose the path you need based on the results of previous tasks. This flexibility can significantly enhance the efficiency of your data integration processes, ultimately saving you time and ensuring data integrity.<\/p>\n

    For additional information, you can check articles for Advanced file system task<\/a>, Secure FTP task<\/a> and Validator task.<\/a><\/p>\n

    You can apply this approach to other components where you need to capture a result in a variable and then use the Validator Task.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction In SQL Server Integration Services (SSIS), validating expressions, paths, and URLs is a crucial part of ensuring the integrity and success of your data integration processes. In this article, we’ll explore how the Validator Task can help you achieve this. Before we dive into practical examples, be sure to check our comprehensive Validator Task […]<\/p>\n","protected":false},"author":5,"featured_media":10644,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\r\nExamples with Validator task | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Examples with Validator task - ZappySys Blog\" \/>\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\/examples-with-validator-task\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Examples with Validator task | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Examples with Validator task - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2023-10-19T22:21:16+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1090\" \/>\r\n\t<meta property=\"og:image:height\" content=\"484\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/\",\"url\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/\",\"name\":\"Examples with Validator task | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png\",\"datePublished\":\"2023-10-19T22:21:16+00:00\",\"dateModified\":\"2023-10-19T22:21:16+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"Examples with Validator task - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png\",\"width\":1090,\"height\":484,\"caption\":\"Configurate the validator task to compare two string.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Examples with Validator task\"}]},{\"@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\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Examples with Validator task | ZappySys Blog","description":"Examples with Validator task - ZappySys Blog","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\/examples-with-validator-task\/","og_locale":"en_US","og_type":"article","og_title":"Examples with Validator task | ZappySys Blog","og_description":"Examples with Validator task - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/","og_site_name":"ZappySys Blog","article_published_time":"2023-10-19T22:21:16+00:00","og_image":[{"width":1090,"height":484,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/","url":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/","name":"Examples with Validator task | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png","datePublished":"2023-10-19T22:21:16+00:00","dateModified":"2023-10-19T22:21:16+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"Examples with Validator task - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/examples-with-validator-task\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/Validator-task-variable-example.png","width":1090,"height":484,"caption":"Configurate the validator task to compare two string."},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/examples-with-validator-task\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Examples with Validator task"}]},{"@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\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10637"}],"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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=10637"}],"version-history":[{"count":3,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10637\/revisions"}],"predecessor-version":[{"id":10648,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10637\/revisions\/10648"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/10644"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=10637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=10637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=10637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}