locked
conditional split RRS feed

  • Question

  • Using the oledb source, I can run a select query on table joins
    Then there is a conditional split control which narrows down the result base on a criteria i.e. field1 is null and field2 is not null.
    Question.
    How can I place the result of this into a table?
    I basically would like to place the result of the conditional split into a table.
    I tried placing a oledb destination but do not want to use a permanent table because I would like the result to go into a temp table.
    Not sure how to place the insert into #tmptable from the result of the conditional split.
    Any suggestions please?
    Thanks
    Friday, July 8, 2011 3:27 PM

Answers

  • Not sure why you cannot do two Execute SQL tasks, please see if this post helps:

    http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx and if not then this one:

    http://ezkantoniblog.tk/ssis_conditional_split_lil_bow_wow_fresh_azimiz.html


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Todd McDermid Friday, July 8, 2011 5:08 PM
    • Marked as answer by Challen Fu Wednesday, August 10, 2011 9:28 AM
    Friday, July 8, 2011 3:33 PM
  • Use the property RetainSameConnection=TRUE For the connection manager OLEDB Connection..

    And Before DATA Flow Create #Temp Table Using Execute SQL TASK.

     

    So that You Can Achieve your Goal..

     

    • Marked as answer by Challen Fu Wednesday, August 10, 2011 9:28 AM
    Monday, July 11, 2011 5:38 AM

All replies

  • Not sure why you cannot do two Execute SQL tasks, please see if this post helps:

    http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx and if not then this one:

    http://ezkantoniblog.tk/ssis_conditional_split_lil_bow_wow_fresh_azimiz.html


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Todd McDermid Friday, July 8, 2011 5:08 PM
    • Marked as answer by Challen Fu Wednesday, August 10, 2011 9:28 AM
    Friday, July 8, 2011 3:33 PM
  • Use the property RetainSameConnection=TRUE For the connection manager OLEDB Connection..

    And Before DATA Flow Create #Temp Table Using Execute SQL TASK.

     

    So that You Can Achieve your Goal..

     

    • Marked as answer by Challen Fu Wednesday, August 10, 2011 9:28 AM
    Monday, July 11, 2011 5:38 AM