ETL is a process used to move data from one system and data structure to another. One tool used for this process is called SSIS.

Use SSDT to build an SSIS package.

Can you provide examples on the following:

1. How to extract the datafile provided by your instructor and use SSMS to map the datafile's columns into a SQL table?

2. In SSDT, Create Data Flow Task to perform the following: - Use the Other Sources section to import the datafile. - Use the Derived Column component to transform the datafile: concatenate first and last names into one column, "Full Name," in your SQL table, and map the "Hire date" column as date in your SQL table with the following format mm-dd-yyyy. - Use the Other Destination section to load the datafile in your SQL table. - Verify the completion of the ETL process by retrieving the data from your SQL table.

3. Explain with examples, a minimum of 3 data flow components of SSIS.