Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-05 : 11:23:28
|
| In control flow there is a dataflow.In dataflow, there is oledb source to do a select query. then there is a conditional split. Based on the conditional split, I want to run a execute sql task. The problem I am having is that the execute sql task is inside the control flow and do not see how to take the data from the conditional split in dataflow to the execute task in control flow.Any thoughts please?Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-05 : 11:30:42
|
| You mean you want to run an sql task for every row in one part of the conditional split in the dataflow?Ho about outpt the data to a table then access that in the sql task?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-05 : 11:33:47
|
| I can do that too but it has to be a temp table and not a permanent table. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-05 : 11:37:39
|
quote:
Originally posted by arkiboys
I can do that too but it has to be a temp table and not a permanent table.
Why?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-05 : 11:39:54
|
| Business requests.Thanks |
|
|
|
lightsql
Starting Member
17 Posts |
Posted - 2011-07-20 : 04:35:52
|
| Seems like you want to run a statement on each rows from the resulting split, why not use the OLE DB Command instead? |
|
|
|
|
|
|
conditional split