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
- Wildcards and regex patterns
- Runs in your environment
- Also runs in Azure Data Factory
- Continue on error options

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
Folder operations
Create and delete folders.
- Delete a folder, including subfolders
- Create a folder if it does not exist
- Auto create missing target directory
Bulk rename
Rename all selected files with one pattern.
- For example
{%name%}.{%ext%}.oldrenames files to *.old
Search & replace
Search and replace text in files.
- Regular expression search supported
- Change file encoding (UTF8, UTF16, or ASCII)
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
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
Placeholders in paths
Timestamp folders or files easily.
- For example
c:\Archive\{{System::StartTime,yyyMMdd}}
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
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
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%}.oldas 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
SQL Server 2012–2025
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

Delete files that match.
Delete multiple files with a wildcard. Combine it with Filter and Sorting to delete only files older than X days or larger than Y.
- Wildcard source path
- Filter by age, size, or extension

Rename with a pattern.
Rename multiple files using placeholders in the new file name, such as {%ext%}-{%name%}-{%timestamp%}.{%ext%}.
- Placeholders for name, extension, and timestamp
- Wildcard source path

Edit text inside files.
Search and replace a string in one or more files, with normal, extended, or regular expression search, an encoding choice, and an ignore case option.
- Regular expression support
- Change encoding as a separate action

Loop through files.
Get a sorted file list as an ADO.NET DataTable and loop through it with a ForEach Loop (ADO Enumerator).
- Sorted and filtered list
- Files or folders

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.
-
Filter examples in the task
The Examples link next to Where lists the syntax.
AgeInDays > 5 LastEditInDays <> 0 Size < 100 Name IN ('File1.txt', 'Download.msi') FullPath LIKE 'c:\temp\ds*' Extension IN ('.txt','.csv') IsReadOnly = True -
Where
Where
Size> 1024 AND AgeInDays > 10Add
AND Extension IN('.txt','.csv')to keep only txt and csv files. -
What the full filter keeps
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.
Articles
Worked examples that use Advanced File System Task.
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.
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.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.