none
SSIS ETL package container usage question RRS feed

  • Question

  • Hi, 

    I have a question,  ssis package needs to loop 100,000 times which container is used?

    Thanks!


    Red

    Monday, September 30, 2019 11:22 PM

All replies

  • Hi Red987,

    You could use ForEach Loop container in SSIS.

    There is a tutorial you can refer to step by step, please check SSIS ForEach Loop File Enumerator.

    Regards,

    Zoe


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, October 1, 2019 1:14 AM
  • Hi, 

    I have a question,  ssis package needs to loop 100,000 times which container is used?

    Thanks!


    Red

    Hi Red,

    If you need to loop the package itself, here repeating runs implied, then you need to use the SQL Agent job and wrap into it an SSIS step, schedule it then as you see it fit, but please be aware that unconditional loops in ETL is not a prudent practice.


    Arthur

    MyBlog


    Twitter

    Tuesday, October 1, 2019 8:16 PM
    Moderator