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 |
|
DLTaylor
Posting Yak Master
136 Posts |
 Posted - 2012-01-31 : 06:06:46
|
| I have a SSIS package that loads data from a text file to a SQL Table.After the SSIS has run i apply Transformations within as usp.UPDATE Table1SET[Col1] = CASE WHEN (LEN([Col2]) < 11) THEN [Col2] ELSE [Col1] ENDNow im sure i can do this using the dft derived colum...Can someone help me with the syntax to use in the expression editor?or is there an argument to keep the update wrtiient as a usp in TSQL?ThanksDan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-31 : 13:34:47
|
| why do you need derived column here? you're trying to update a field in table using another field values. i dont think there's a need of derived column here (unless i'm missing something). I think whatever you're doing is best way to do it in set based manner.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
dft Deived Colum Expression