ssis

• Getting started with ssis
• Learn Tutorial
• Check if a file exists
• Convert datatype from Integer in YYYYMMDD format to Date
• Using Built in conversion
• Using Scripting Component
• 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