Home Forums Data Warehousing Integration Services Query help for Data pulling RE: Query help for Data pulling
Ray M
SSC-Insane
Points: 21093
More actions
April 3, 2013 at 3:07 pm
#1603382
In the Derived column transformation you add 3 rows.
and the expression for DRU would be a very simple one.
Cost == "DRU" ? Values : NULL(DT_I4)
Of course repeat the process for the Disk and Tape by adding 2 more derived columns.
Edit: Added Image