SSIS Advanced File System Task

⚡ Key Benefits

• Process single or multiple files at once using wildcards — no loops or scripting needed
• Filter, sort, and select files using SQL-like expressions (Size, AgeInDays, Extension)
• Bulk rename, search/replace content, and change file encoding in a single task
• Use dynamic placeholders for timestamp-based archiving and staging
• Built-in continue-on-error handling for production-grade reliability

📸 Visual Overview & Setup

1. Drag & Drop from SSIS Toolbox 🔍 View Full Size	2. Copy Multiple Files (Wildcard) 🔍 View Full Size	3. Delete Files (Wildcard) 🔍 View Full Size
4. Advanced Sorting & Filtering 🔍 View Full Size	5. Rename Multiple Files (Pattern) 🔍 View Full Size	6. Search & Replace in Files 🔍 View Full Size

🔧 Key Features

File & Folder Operations

• Copy, Move, Delete, Rename files — single or bulk via wildcard (e.g. *.csv)
• Write text to new files and retrieve file properties
• Create and delete folders; auto-create missing target directories

Bulk Rename & Dynamic Paths

• Rename files using name patterns (e.g. {%name%}.{%ext%}.old)
• Use dynamic placeholders anywhere in paths (e.g. c:\Archive\{{System::StartTime,yyyyMMdd}})

Smart Filtering & Selection

• SQL-like filter expressions (e.g. Size > 1024 AND AgeInDays > 10 AND Extension IN('.txt','.csv'))
• Regex-based include/exclude patterns (e.g. ^(file\d\d).(\w+)$)
• Sort by any property and select Top-N files (e.g. Order Size DESC)

File Content Processing

• Search & Replace across single or multiple files (Regular Expression supported)
• Change file encoding (UTF-8, UTF-16 / Unicode, ASCII)

Metadata & Loop Support

• Get file properties as a data table for easy looping
• Use with ForEach Loop container (ADO Enumerator)

Reliability & Error Handling

• Continue on error (e.g. copy only when source file exists)
• Check file existence for single or multiple files

💡 Common Use Cases

Real-world scenarios where this task simplifies SSIS development:

• File Archiving & Organization: Move processed files into timestamped folders automatically.
  Example: Archive daily files into c:\Archive\yyyyMMdd using dynamic placeholders.
• Log Cleanup & Retention: Delete or archive old files based on age and size rules.
  Example: Remove files where AgeInDays > 30 AND Extension IN('.log','.tmp').
• Selective File Processing: Process only files matching specific criteria before loading into a database.
  Example: Pick CSV files larger than 1 KB modified in the last 7 days.
• Dynamic File Renaming: Standardize or timestamp file names in bulk before downstream processing.
  Example: Rename using {%name%}_{%date%}.csv pattern.
• Pre-Processing & Content Cleanup: Prepare file content before ETL import.
  Example: Convert encoding to UTF-8 or strip invalid characters with Regex search/replace.
• Sorted File Looping: Get an ordered file list and iterate through it in your SSIS package.
  Example: Process top 10 largest files first using Order Size DESC.

🎯 Summary

Turn SSIS into a powerful file automation engine.
Eliminate scripting, simplify complex file workflows, and handle bulk copy/move/delete/rename operations with a drag-and-drop task UI.

About ZappySys SSIS PowerPack

This task is part of ZappySys SSIS PowerPack, a suite of 100+ high-performance connectors and tasks for SQL Server Integration Services.

• Connect to APIs, cloud apps, databases, and file systems
• Reduce development time with drag-and-drop, no-code components
• Trusted by thousands of organizations worldwide

Download Free Trial →