I found this very useful microsoft blog on considering various Configuration options for SSIS packages and their advantages/disadvantages, thought I would share it across with all my fellow SQL developers: http://msdn.microsoft.com/en-us/library/cc671625.aspx