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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-02-04 : 05:55:39
|
| Hi,Is it possible to assign the column value to a user defined variable? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-04 : 06:02:16
|
| Yes. its possible. But you need to explain where you are trying to do this and in which task etc? |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-02-04 : 06:16:39
|
| I created a package to load a fact table.This package has both error handling and logging.The 'process id' generated in the log table should match the 'process id' in the error table.The errors are captured from the look-up transformation.So is it possible to store the value from the log table in a variable and later update the error table with that value? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-04 : 06:24:22
|
| Yup. you can define a user defined variable and include an output parameter in your SP which saves log table record. Through this output parameter you get generated id which you can map to this user defined variable in parameter mapping tab. then you can later use this variable in place where you want this value. Hope its clear now. |
|
|
|
|
|
|
Assigning value to a variable