SSIS Tips

1. During the SSIS package development,
         We can consider
               Including variables and having the count of rows of important tables and details.
               
          At the end, we can provide an email task, 
          to include the following details: (Choose what is better for your reqs)

           Subject: [DBServer]: Package: [Package Name]: Success | FAILURE

           Body: 
                    Package: [Package Name] = Success | FAILURE @ Date & Time (Note: Either use here Date & Time or Started /Ended Date&Time)
                    Started: Date&Time (Optional - only use for long packages - including seconds)
                    Ended: Date&Time (Optional - only use for long packages - including seconds)
                    
                    Variables:
                          BatchID: nnnn
                          Package Exec Key: nnnn
                          DatabaseName.SchemaName.TableName: Row Count: 
                          DatabaseName.SchemaName.TableName: Row Count: 
                          FYI Variable Values: 
                          [Other Variables - including dynamic values, this will help in long term]