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 |
|
Unikhath
Starting Member
12 Posts |
 Posted - 2008-09-08 : 13:16:22
|
| Hi, I have a doubt using derived column task. When we add a new column using the derived column task in the data flow, will that adds a new column to the table in the database or that just adds a virtual column during the data flow. Where does the data, of the derived column is being added??? I’m adding a new column and name it as Reason and specify the reason ….and I update the table to which I’m making changes with the reason specified in the Derived column tasks. But when I chk by database table I don’t see the column and the data….Please help….Thanks. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-08 : 16:03:54
|
| Derived column is created and labeled 'Derived Column 1' by default (you can rename this too.) You can however, under Derived Column, choose "Replace 'Orginal Column Name'" to overwrite evaluated column with new value.If choose not to overwrite then you need to connect new derived column (Derived Column 1) to the existing table field you'd like overwritten. |
 |
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-09-18 : 11:39:06
|
| Hi,Yes. It should show as a new column named either DerivedColumn1 or any name that you might have given. If you are not able to see it in the destination table, then I think that while mapping in the destination table, you might be making a mistake.Make sure that you map the new derived column properly and then it should be displayed in the result set.Hope this helps.Good Luck.- notes4we |
|
|
|
|
|
|
SSIS- Derived column Task