ssis

• Getting started with ssis
• Learn Tutorial
• Check if a file exists
• Steps to check if a file exist or not
• Using loop control to run a dataflow task for every file.
• Convert datatype from Integer in YYYYMMDD format to Date
• Create a CSV file and write from SQL Server into that file
• How to use variables inside a script component
• Load multiple CSV files of same format from a folder
• Move file from one folder to another
• Read from a CSV file
• Sorting incoming data, but send forward only a subset of rows