I have more than 100 SSIS packages to run. These packages load data from Oracle into MSSQL DW.
Which is faster to run 100 packages in parallel or sequentially? Any problems we can foresee if we run 100 packages in parallel in MS SQL 2012
Also, how do I got email alert if one or two packages run failure?