wasabi3689
asked on
running many ssis package
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.