none
Conditional split in control flow

    Question

  • Hi

    I would like to find some dtsx files as examples to solve this question :

    Need to read a field in a table, loop on each value in the column and run this appropriate package depending of each value

    Many thx for help and examples

    Wednesday, March 12, 2014 7:10 AM

Answers

All replies

  • Hi,

    Try this link for an example - http://beyondrelational.com/modules/2/blogs/101/posts/13466/ssis-loop-through-rows-in-a-sql-table-with-multiple-columns.aspx


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Wednesday, March 12, 2014 7:32 AM
    Moderator
  • Depending on the number of packages you could add one dummy task in the foreach loop you're using to loop through that table.

    Then add multiple Execute Package Tasks and then connect the dummy task to all Execute Package Tasks. On each arrow you can add an expression to check certain conditions.

    This works fine for a couple of different values/packages, but is perhaps not that maintainable/readable for a whole bunch of different values/packages.


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Wednesday, March 12, 2014 8:01 AM
    Moderator
  • Thx but i don t see the conditional split to execute the appropriate child package ?
    Wednesday, March 12, 2014 8:03 AM
  • An alternative is to store the package name in the table. Then you could loop through the table and then use an expression on the Execute Package Task (connection) to execute the correct package.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Wednesday, March 12, 2014 8:04 AM
    Moderator
  • Okay it s approximatively what i ve done for the moment in waiting for some best solutions ...

    Have u got some dtsx exp or some links to show this ?

    thx

    Wednesday, March 12, 2014 8:06 AM
  • Thx but i don t see the conditional split to execute the appropriate child package ?
    This is how you could implement a conditional split functionality:

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Wednesday, March 12, 2014 8:14 AM
    Moderator
  • You've already got enough resources to get your job done. What else are you expecting?

    And what according to your represent best solution? What was the problem with suggested approaches?


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, March 12, 2014 8:17 AM
  • Okay it s approximatively what i ve done for the moment in waiting for some best solutions ...

    That's probably the most flexible solution. If you are using 2012 project deployment then you could use an expression on the Execute Package Task and else you use an expression on the ConnectionString of the connection manager that is used by the Execute Package Task.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Wednesday, March 12, 2014 8:19 AM
    Moderator