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 |
|
Trekmp
Starting Member
6 Posts |
 Posted - 2008-05-21 : 09:05:12
|
| I've been given the task of moving data from an old system to a new one. That's easy enough apart from some of the data fields do not match in the least:Example: In the old system (tableOld) there is a field that contains text data such as 'Laboratory','Field','Market','Demo','Development', but this one field could contain one or more of these. In the new system (tableNew) there are boolean fields for each of the above.What I need is a way to check for these and then make sure the correct field(s) gets ticked (1 entered into the field) in the new system.Any suggestions, just trying to get my head around SSIS.Thanks for any help provided. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-21 : 11:41:32
|
| Use a derived column task and use a CASE expression to get value of each bit. |
 |
|
|
Trekmp
Starting Member
6 Posts |
Posted - 2008-05-22 : 06:13:53
|
| Thanks, that worked great.Thanks for any help provided. |
|
|
|
|
|
|
Moving data from old to new system