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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-04-08 : 12:05:31
|
| we have designed a system that requires that query sources be read from a read only (R/O) server and written to server with R/W.This works well using the SCD wizard, because the source query which uses the R/O is in the OLE DB data flow step above it in the package. But when the Lookup transformation wizard puts the source query INSIDE the transform itself. this presents a problem because i cant have more than one connection string in operation at once. Can i get the Lookup transform to use as input the data from the previous OLE DB step somehow? Failing that, is there another way to do a lookup using source data from one connection and update a file after doing the lookup on another (i.e. destination ) connection? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-12 : 13:50:33
|
| currently are lookup and oledb inside same data flow? if yes you can make oledb source of lookup |
 |
|
|
|
|
|
can i get lookup to use data from 2 diff connects?