How to Develop a SSIS Package which can perform task like:-
1. Received File from SFTP, the File Format is .csv.
2. Load the File to Existing table in sql server
3. Perform Validation and Checks
4. Generate the Clean .csv
5. Upload the file to customer SFTP
6. Logging and Error Handling with table creation in sql server
I am very new to SSIS, Appreciate your help and Guidence.
Thanks a lot