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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics