Content

• Video Tutorial
• Step-By-Step
• Properties
• Setting UI
• See Also
• References

Video Tutorial

1. Firstly, You need to Download and Install SSIS PowerPack from here (Skip this if you already did)
2. Launch Visual Studio, Create or Open your existing SSIS Solution.
3. In the Control Flow, drag and drop the ZS Validation Task included in the ZappySys PowerPack.
   
4. Lets create variable for save validation status to variable. You can create now or you can create while configure below task.
5. Double click the Validation Task and lets configure it.
6. in Validation Action select the Check if file exists and Select path for file or folder.

   Note: If you want to operation with multiple files then use wild card pattern as below (when you use wild card pattern in source path then system will treat target path as folder regardless you end with slash ).
   
   Examples:
   c:\data\file123.csv (single file)
   c:\data\file*.csv (all files starting with file)
   c:\data\subfolder\*.csv (all files with .csv Extension and located under folder subfolder)
   

   
7. Click on OK to save Settings.
8. Here also you can Check if folder exists (single file or pattern)
   
9. Click on OK to save Settings.
10. Now you can run or execute task. You will get result in True or False (If exist or not).

Lets Check SSIS expression (true or false)

1. Firstly we need to create a variable with Integer DataType and add Value in Number.
2. Lets Create Age Variable.
   
3. Double click the Validation Task and in Validation Action select the Check SSIS expression (true or false).
   
4. Thats all, hit on OK button for save settings.

Here we can Validate for file content or file size

1. Lets Double click on Validate for configure it.
2. Select Check file property and file path.
   
3. We have more Property to check file for see below image.
   
4. Lets Check folder property using ZS Validation Task
   
5. We have more Property to check folder for see below image.
   
6. Now, click on OK button for save Validation Task Setting UI.
7. Just run or execute your Task.

Setting UI

See Also

• SSIS Secure FTP Task
• SSIS Timer Task
• SSIS Regular Expression Parser Task
• SSIS Logging Task