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 |
|
abarringer
Starting Member
13 Posts |
 Posted - 2006-02-16 : 15:23:20
|
| I'm trying to import a text file using SQL2005 SSIS that contains a byte column with values 0-F.I need to use the derived column expression editor to "and" this column.Similar to this Expression((4 & mybytecolumn) == 1)?1:0where mybytecolumn = "C"kDo any of you know what to cast mybytecolumn to that will support this operation? Casting mybytecolumn as a number works as long as my byte does not exceed 9 (such as A-F).Thanks for your help,Andrew |
|
|
|
|
|
Bytes and SSIS Expressions