 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check outour products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
Advanced SSIS File System Task
Advanced SSIS File System Task is designed to full fill most common file system related operations in SSIS. Native SSIS File System Task provided by Microsoft lakes many useful features (e.g. copy/move/delete/rename multiple files, search/replace etc).
Features
- File operations for single or multiple files using wildcard(e.g. copy, move, rename, delete, write to file, get properties)
- Folder operations such as delete folder and create folder
- Support for bulk rename (e.g. by specifying {%name%}.{%ext%}.old as new name will rename all selected files to *.old)
- Search and Replace in files (Regular expression search supported)
- Change file encoding
- Get file properties as data table which you can loop easily (Using ForEach Loop - ADO Enumerator)
- Option to continue on error (e.g. Copy file only when source file found)
- Auto create missing target directory
- Use placeholders anywhere in the path, makes it easy to timestamp folders or files (e.g. c:\Archive\{{System::StartTime,yyyMMdd}})
- Regular Expression based Include Pattern (e.g. ^(file\d\d).(\w+)$ will include file01.exe,file22.csv ...)
- Regular Expression based Exclude Pattern (e.g. (.exe|.msi) will exclude files with extension exe or msi)
- Sort based on specific property (e.g. Order Size DESC - extract top 10 files by size)
- Advanced SQL like filter support (e.g. Size> 1024 AND AgeInDays > 10 AND Extension IN('.txt','.csv') will include file greater than 1024 bytes and extension is txt or csv)
- Support for Regular Expression based Include Pattern (e.g. ^(Customer\d\d).(\w+)$ )
- Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
