conditional split
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
July 8th, 2011 11:33am
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.htmlArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 11:39am
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..
July 11th, 2011 1:40am