SSIS Testing Plan:
1. Verify all tables have been imported.
2. Verify all rows in each table have been imported.
3. Verify all the columns specified in source query for each table have been imported.
4. Verify all the data has been received without any truncation for each column.
5. Verify the time taken /speed for transfer
6. Verify if Project Version is compatible with SQL Server Version on the server
7. Verify data types from source are consistent with destination (data type, data length, index/constraint)
8. Verify that all the expected data is loaded in target from the source, data completeness testing is done.
9. Some of the tests that can be run are compare and validate counts, aggregates and actual data between the source and target for columns with simple transformation or no transformation.
10. This testing is done to ensure that the data is accurately loaded and transformed as expected.