Advanced SSIS File System Task - Copy, Move, Rename, Delete

SSIS Validation Task

SSIS Validation Task can be used to perform most common checks during ETL process. Such as file exists, file is not empty, file contains certain string pattern etc.

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

In the Control Flow, drag and drop the ZS Validation Task

SSIS Check File Exists (Use wildcard)

SSIS Validation Task – Check File Exists (Use wildcard)

SSIS Check File Content (Use wildcard)

SSIS Validation Task – Check File Content

Check SSIS Expression output

SSIS Validation Task – Check SSIS Expression output

Articles / Tutorials

How to Read / Write DynamoDB data in SSIS (Query, Insert, Update, Delete)

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.).Â We will discuss how to useÂ SSIS DynamoDB Source Connector […]