Included in SSIS PowerPack

SSIS Advanced File System Task

The file operations the native SSIS File System Task lacks.

Copy, move, rename, and delete multiple files using wildcards. Search and replace in files, change file encoding, and filter and sort files by size, age, or extension, all without coding.

The trial includes Advanced File System Task and every other PowerPack component

Advanced File System Task in SSDT
Advanced SSIS File System Task copying multiple files with a wildcard
Copy file(s) with a wildcard source pathExplore 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 Advanced File System Task can do

Advanced File System Task covers the most common file system operations in SSIS. The native SSIS File System Task lacks many useful features, such as copying, moving, deleting, or renaming multiple files, and search and replace.

Multiple-file operations

File operations for one or many files using wildcards.

  • Copy, move, rename, and delete
  • Write to a file or append to it
  • Get file properties

See the actions

Folder operations

Create and delete folders.

  • Delete a folder, including subfolders
  • Create a folder if it does not exist
  • Auto create missing target directory

See the actions

Bulk rename

Rename all selected files with one pattern.

  • For example {%name%}.{%ext%}.old renames files to *.old

See rename

Search & replace

Search and replace text in files.

  • Regular expression search supported
  • Change file encoding (UTF8, UTF16, or ASCII)

Search and replace guide

Filter & sort

Advanced SQL-like filter and sorting.

  • Regex include and exclude patterns
  • Sort on a property, e.g. top 10 files by size
  • Filters such as AgeInDays > 10

See the filter example

File list for looping

Get file properties as a data table.

  • Loop with a ForEach Loop (ADO Enumerator)
  • File or folder list as an ADO.NET DataTable

Looping guide

Placeholders in paths

Timestamp folders or files easily.

  • For example c:\Archive\{{System::StartTime,yyyMMdd}}

Help file

Get file information

Check files before you act on them.

  • File exists, folder exists, lock status
  • File count, size, and last modified date
  • Latest or oldest file path

All actions

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

See all features
  • File operations for single or multiple files using wildcards (e.g. copy, move, rename, delete, write to file, get properties)
  • Folder operations such as delete folder and create folder
  • Bulk rename (e.g. {%name%}.{%ext%}.old as the new name renames all selected files to *.old)
  • Search and replace in files (regular expression search supported)
  • Change file encoding
  • Get file properties as a data table that you can loop through (ForEach Loop, ADO Enumerator)
  • Option to continue on error (e.g. copy a file only when the source file is found)
  • Auto create missing target directory
  • Placeholders anywhere in the path to timestamp folders or files (e.g. c:\Archive\{{System::StartTime,yyyMMdd}})
  • Regular expression based include pattern (e.g. ^(file\d\d).(\w+)$ includes file01.exe, file22.csv)
  • Regular expression based exclude pattern (e.g. (.exe|.msi) excludes exe and msi files)
  • Sort on a specific property (e.g. order by Size DESC to get the top 10 files by size)
  • Advanced SQL-like filter (e.g. Size> 1024 AND AgeInDays > 10 AND Extension IN('.txt','.csv'))
  • 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

Pick an action

One task, many file actions.

Choose the action, point it at a path with a wildcard, and narrow the files with Filter and Sorting.

Copy or move many files at once.

Set the source path with a wildcard such as D:\Zappysys\Test\*.txt, optionally scan subfolders, and set the target path. Placeholders can build a dated target folder.

  • Recursive scan (include child folders)
  • Overwrite options
  • Create target folder if missing
Copying multiple files with a wildcard

Inside the UI

Key settings, as they appear in SSDT.

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

Copy multiple files

Use a wildcard in the source path.

Filter example

Act only on the files you mean.

From the product page: a SQL-like Where filter on the Filter and Sorting tab narrows the files any action works on.

  1. Filter examples in the task

    The Examples link next to Where lists the syntax.

    Examples

    AgeInDays > 5
    LastEditInDays <> 0
    Size < 100
    Name IN ('File1.txt', 'Download.msi')
    FullPath LIKE 'c:\temp\ds*'
    Extension IN ('.txt','.csv')
    IsReadOnly = True
  2. Where

    WhereSize> 1024 AND AgeInDays > 10

    Add AND Extension IN('.txt','.csv') to keep only txt and csv files.

  3. What the full filter keeps

    As described on the product page
    Condition Keeps files
    Size> 1024 greater than 1024 bytes
    AgeInDays > 10 older than 10 days
    Extension IN(‘.txt’,’.csv’) with extension txt or csv

    Combine with Sort By and Top to pick, for example, the top 10 files by size.

Filter from the Advanced File System Task product page. Examples list from the task’s Examples dialog shown in its screenshot.

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 Advanced File System Task on the canvas.

How is it different from the native File System Task?

The native SSIS File System Task lacks features such as copying, moving, deleting, or renaming multiple files and search and replace. This task adds wildcards, regex patterns, filters, and sorting.

Can I delete files older than X days?

Yes. Use a Where filter such as AgeInDays > 10 on the Filter and Sorting tab with the delete action.

Can I rename many files at once?

Yes. For example {%name%}.{%ext%}.old as the new name renames all selected files to *.old.

How do I loop through files?

Get the file list as an ADO.NET DataTable and loop through it with a ForEach Loop (ADO Enumerator).

What if the source file is missing?

Turn on continue on error, for example to copy a file only when the source file is found.

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.

Where is the full property reference?

Open the Advanced File System Task help file for all actions and properties.

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 Advanced File System Task onto the Control Flow.

Pick an action, set a wildcard path, and run, with no coding required.

  • Control Flow Task in SSISAdvanced File System 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