BIML, trying to nest containers in containers

• Lowell

  SSC Guru

  Points: 323504

  More actions

  April 13, 2017 at 9:35 am

  #401943

  I'm trying to structurally come up with a design for BIML. 
  i'll have a dynamic number of tables, but what i'm trying to do is have for parallel sequence containers, and each container has nested containers, where i would put the ETL for each actual table. I'd like it t look something like this:

  

  so I seem to be able to do the first level logical grouping with this code example
  <Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Packages>
   <Package Name="MyLookup Package" ConstraintMode="Parallel" AutoCreateConfigurationsType="None">
    <Tasks>
     <Container Name="One Container To Rule Them All" ConstraintMode="Parallel">
      <Expressions></Expressions>
      <Tasks>
      <#
      int maxRecords = 250;
      for(int i = 1; i <= maxRecords; i++)
       { #> 
       <# if(i %50 == 0)
        {#>
         <Container Name="Table <#=i - 49#> to <#=i#>" ConstraintMode="Parallel"><Tasks>
       <# } #>
       <!--Meat and potatoes: stuff inside each grouping container? -->
       <# if(i %50 == 0) { #>
          </Tasks></Container>
       <#} #>
      <#} #>
      </Tasks>
    </Container>
    <!--One Container To Rule Them All -->
    </Tasks>
   </Package> 
  </Packages>
</Biml>
  
  but as soon as i put a sequence container in the "Meat and potatoes:" comment area,
  with a snippet like this:
        <Container Name="Process Table <#=i#>" ConstraintMode="Parallel"></Container>
  i get 200+ sequence containers, plus the grouping ones i made before, instead of then being inside a "Grouper".
  i THINK my problem is i'm thinking biml is like the old ASP pages, where they are Response.Writing out stuff.
  
  if you have BIML set up, can you point me to wher ei'm making a mistiake

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!