Test cases For SSIS Project :
Testing For a SSIS project Is very important question in interviews.
@ Verify all the tables have been imported
@ Verify all the rows in each table have been imported
@ Verify all columns specified in source query for each table have been imported
@ Verify all the data have been recived without any truncation for each column
@ Verify the schema at source and destination
@ Verify the time taken /speed for data transfer
@ Fields truncated due to diffence in length of the field.
