How many child SSIS packages can be called in parent or master package ? any limit?

  • HI Champs,
    How many child packages can be called  inside  master package ? is there any limit for that ?  how many can be called in parallel ?
    because am getting  out of memory issue . am having around 27 child package in one master package. other than reducing the no what else can be done ?
    Regards,
    Ravi

  • ravi@sql - Friday, November 3, 2017 6:01 AM

    HI Champs,
    How many child packages can be called  inside  master package ? is there any limit for that ?  how many can be called in parallel ?
    because am getting  out of memory issue . am having around 27 child package in one master package. other than reducing the no what else can be done ?
    Regards,
    Ravi

    It would seem that available RAM is your limit, regardless of any overarching absolute limit, which is presumably little more than an academic question in your case.
    Try using multiple SEQUENCE containers in series to limit the number of packages which can execute in parallel.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • ravi@sql - Friday, November 3, 2017 6:01 AM

    HI Champs,
    How many child packages can be called  inside  master package ? is there any limit for that ?  how many can be called in parallel ?
    because am getting  out of memory issue . am having around 27 child package in one master package. other than reducing the no what else can be done ?
    Regards,
    Ravi

    While what Phil is saying is a good idea, it may just hide the real issue.   The question is whether each such package is being reasonably efficient with it's use of resources, like RAM.   I'd be looking to see just how much RAM each of these packages is using, and also asking just how much RAM is on the SSIS box that you're actually running out...   Another possible scenario is that you are processing too much data in a package that runs in 32 bit mode, and thus is limited to an address space of at most 4 GB, and possibly only 2 GB, depending on the exact circumstances.   If you provide significantly more detail, we might be able to help address efficiency and/or provide you the kind of logical reasoning needed to convince management to get more RAM.

  • sgmunson - Monday, November 6, 2017 6:57 AM

    ravi@sql - Friday, November 3, 2017 6:01 AM

    HI Champs,
    How many child packages can be called  inside  master package ? is there any limit for that ?  how many can be called in parallel ?
    because am getting  out of memory issue . am having around 27 child package in one master package. other than reducing the no what else can be done ?
    Regards,
    Ravi

    While what Phil is saying is a good idea, it may just hide the real issue.   The question is whether each such package is being reasonably efficient with it's use of resources, like RAM.   I'd be looking to see just how much RAM each of these packages is using, and also asking just how much RAM is on the SSIS box that you're actually running out...   Another possible scenario is that you are processing too much data in a package that runs in 32 bit mode, and thus is limited to an address space of at most 4 GB, and possibly only 2 GB, depending on the exact circumstances.   If you provide significantly more detail, we might be able to help address efficiency and/or provide you the kind of logical reasoning needed to convince management to get more RAM.

    Good point. The design of each package is an important factor. If they're doing lookups or aggregations, for example, RAM usage is likely to be heavy regardless of parallelism.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply