Topics

• Check if a file exists
• Sorting incoming data, but send forward only a subset of rows
• Load multiple CSV files of same format from a folder
• Create a CSV file and write from SQL Server into that file
• How to use variables inside a script component

Examples

• Using Sort and Conditional Split components
• Steps to load data
• Steps to import data
• Steps to check if a file exist or not
• Steps to achieve the objective.