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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-09-20 : 04:50:29
|
| Hi,I have a lookup transformation to get the gender id from table genders according to the gender name in the staging table. How can I now write the update statement in oledb command to update the gender name with the gender ids in the staging table?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-20 : 07:12:00
|
| I'd suggest you use a stored procedure, instead of SQL in the OLEDB command. |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-09-20 : 09:50:22
|
| Thanks. How would i write the stored procedure and send the gender id to the sp in order to update each row with the right id?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
|
|
|
lookup and oledb command