SolvedPrivate

running many ssis package

Posted on 2015-01-22
2
19 Views
Last Modified: 2016-02-11
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?
0
Comment
Question by:wasabi3689
2 Comments
 
LVL 25

Assisted Solution

by:jogos
jogos earned 250 total points
ID: 40565889
That depends on how different objects those packages use.  Same objects and parrallel can lock (writing) or get advantage of cache (reading).   Parallel can for example also be done in a package having different tracks and that already makes it parallel.
Memory, io, cpu's. What kind of SSIS-actions and the volume are big part of the puzzle.
0
 
LVL 18

Accepted Solution

by:
Simon earned 250 total points
ID: 40566230
Agree with Jogos: Many factors in your local environment come into play. I can only suggest trying different scheduling options and set up some diagnostics to capture start and finish times.
Is each package truly independent or are there any pre-requisites for some of the packages?
You might try writing a 'meta-package' that includes all or subsets of the current packages for easier scheduling and performance recording.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now