Included in SSIS PowerPack

SSIS Validation Task

Check files, folders, expressions and patterns during ETL, then fail or record the result.

SSIS Validation Task performs the most common checks during an ETL process, such as whether a file exists, is not empty or contains a certain string pattern. It also checks SSIS expressions, regular expressions and folder properties, and can throw an error or save the validation status to a variable.

The trial includes Validation Task and every other PowerPack component

Validation Task in SSDT
Validation Task - Check File Exists (Use wildcard)
Check if any file matches a wildcard path such as c:\SSIS\*.csvExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Validation Task can do

SSIS Validation Task performs the most common checks during an ETL process, such as whether a file exists, is not empty or contains a certain string pattern. It also checks SSIS expressions, regular expressions and folder properties, and can throw an error or save the validation status to a variable.

SSIS expression check

Evaluate an SSIS expression and check whether it returns true or false.

  • Expression must be Boolean type

Task properties

Regular expression rules

Validate values with regular expression based rules.

  • CheckRegularExpression action
  • RegX and NotRegX match operators

Task properties

File & folder exists

Check whether a file or folder exists, for a single path or a wildcard pattern.

  • Patterns like c:\data\file*.csv
  • SearchPattern and RecursiveScan

Task help

File property checks

Validate a file property such as size, dates, content or lock state.

  • Size, last modified / creation date (local or UTC), age in days
  • Content, file count, name, extension, encoding
  • Exists flag and Is File Locked

Task properties

Folder property checks

Validate folder properties such as total size, file count and age.

  • Folder size, file count, exists flag
  • Creation and last modified dates (local or UTC), age in days

Task properties

Rich comparison operators

Compare the checked value with an expected result using many operators.

  • =, !=, >, >=, <, <=
  • Contains, Starts With, Ends With, RegX Match
  • Between (100#200), In / Not In (comma list)

Task properties

Fail or record the result

Throw an error on failure, or save the status and message to variables.

  • ThrowErrorOnValidationFailure with CustomMessage
  • EnableSaveStatus / StatusVariable
  • EnableSaveMessage / MessageVariable

Task properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

Dynamic paths & logging

Read the path to validate from direct text, a variable or a connection, and control logging.

  • SourcePathAccessMode: Direct, Variable or Connection
  • LoggingMode and PrefixTimestamp

Task properties

See all features
  • Validate business processes in few clicks
  • SSIS Expression check for validation
  • File/folder property validation such as file exists, check size, check content
  • Support for regular expression based validation rules
  • Check if file or folder exists using a single path or wildcard pattern, with recursive scan
  • File properties: size, dates (local or UTC), age in days, content, encoding, file count, locked flag
  • Folder properties: size, file count, dates, age in days, exists flag
  • Operators including Contains, Starts With, RegX Match, Between and In / Not In
  • Throw an error with a custom message on validation failure
  • Save validation status and message into SSIS variables
  • Source path from direct value, variable or connection
  • Logging modes with optional timestamp prefix
  • Check whether a file is locked, then fail or save the status to a variable
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Validation Task page and help file, with the screens you will see in SSDT.

Check that a file, or any file matching a pattern, exists.

Choose Check if file exists (Single file or pattern) and enter a path such as c:\data\file123.csv or a wildcard such as c:\SSIS\*.csv. Turn on Recursive Scan to include child folders. The result is True or False.

  • Path from direct text, a variable or a connection
  • Check if folder exists works the same way
  • Throw an error, or save the status to a variable
Validation Task - Check File Exists (Use wildcard)

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Validation Task product page. Step through them, or open any shot at full size.

Check File Exists

Check if file exists with path c:\SSIS\*.csv and expected result True; Throw error if validation fails is checked.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Validation Task on the canvas.

What is Validation Task?

SSIS Validation Task performs the most common checks during an ETL process, such as whether a file exists, is not empty or contains a certain string pattern. It also checks SSIS expressions, regular expressions and folder properties, and can throw an error or save the validation status to a variable.

What can it check?

Six actions: Check SSIS expression (true or false), Validate Regular Expression, Check if file exists, Check file property, Check if folder exists and Check folder property. File and folder checks accept a single path or a wildcard pattern, with optional recursive scan.

What happens when validation fails?

With Throw error if validation fails (ThrowErrorOnValidationFailure) checked, the task fails, optionally with your CustomMessage. To continue instead, save the result with EnableSaveStatus / StatusVariable and the message with EnableSaveMessage / MessageVariable, then branch on the variable.

Can it check whether a file is locked?

Yes. Use Check file property with Is File Locked. The file lock tutorial stores the lock status in a variable and waits until the file is unlocked before copying it.

Which comparison operators are available?

=, !=, >, >=, <, <=, Contains, Not Contains, Starts With, Ends With, RegX Match, Not RegX Match, Between (e.g. 100#200), In and Not In (comma separated values).

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Validation Task onto the Control Flow.

Validate files, folders and expressions before the next step of your ETL runs.

  • Control Flow Task in SSISValidation Task appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 9