question

Rosalina avatar image
Rosalina asked

Design and Develop SSIS Package to perform Cleansing and Validation Task.

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

c#ssis2012ssis script task
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.