Moving Data From Excel to SQL Server using SSIS Package?

Oct 15 2018 6:06 AM

Please create a SSIS Package to read the excel sheet from a path and insert the rows into a data base.

1. Package should take back up of existing table with _ddmmyyy as postfix.

2. It should delete the existing records from original table

3. It should enter the rows by reading excel row entry

4. Header row should not be inserted into table.

5. Package should validate the columns. This excel columns are defined and their positions should not change.

6. If the excel is not in proper format, an email should be delivered to the support team. Mail id, subject, body should be configurable.

7. If upload is successful, the sheet should be moved to archive folder.

8. Make sure all error handling is done properly.

Any idea?

Answers (1)