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 |
|
Jerry44
Starting Member
4 Posts |
 Posted - 2009-04-07 : 10:15:50
|
| Can you have more than one parameterized query in a lookup transformation?Can an OLEDB source support more than one Lookup? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-07 : 11:25:18
|
| nope you cant have more than one query inside same lookup. but why do you want that? dont you always have to lookup to single resultset?yup..it can support more than one lookup |
 |
|
|
Jerry44
Starting Member
4 Posts |
Posted - 2009-04-07 : 15:12:37
|
| I have several queries and each query returns one cell of data. I was trying to avoid having an OLEDB connection and a Lookup transformation for each cell of data. I'm just learning this and trying to determine which tools I need to perform the task. I'm thinking now that I might need an "Execute SQL Task". I would like to excute multiple SQL statements with one instance of a tool.Thanks for the reply. |
|
|
|
Jerry44
Starting Member
4 Posts |
Posted - 2009-04-08 : 16:30:10
|
| Anyone? |
|
|
|
|
|
|
Question on Lookup transformations