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
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

SSIS Check File Exists (Use wildcard)

SSIS Validation Task - 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

SSIS Validation Task – Check File Content

Check SSIS Expression output

SSIS Validation Task - Check SSIS Expression output

SSIS Validation Task – Check SSIS Expression output

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This