SSIS (SQL Server Integration Service) Exercise

1. Copy data from Employee excel to sql server table.
2. Export data from person.person table to excel file.
3. Copy data from Employee flat file sql server table.
4. Export data from person.person to flat file.
5. Create a package to view free space on C drive (Hint. use WMI Data Reader Task).
6. Create a package to find any new incoming files on C:\SSIS\CheckForNewFiles. (Hint. Create the folder and use WMI event watcher task)
7. Create a package to send mail.(Hint. Use send mail task)
8. Create a package to copy files from C:\SSIS\SourceTxt to C:\MyPackage\DestinationTxt (Create those folder and place example.txt files on source folder)
9. Create a package to open calculator.(Solutions) 
10. Create a package - take person.person table as source.add one column on the fly using derived column Merge First name and last name ,create full name  as a new column.Load the data to a destination sql server table.
11. Using a variable to count Employees imported from Excel. (Solutions)
12.