I am trying to replace the NULL values from my data source before the transactions are inserted into my data warehouse. I want to replace the <NULL> values with a string that actually says NULL. This only needs to be done for a few specific columns, so I wanted to do this using my DTS package that loads the data. So I am trying to use an ActiveX script in the my data transformation for some of the columns and the problem I am having is the vbscript syntax. I cannot figure out how do the following in vbscript.
IF SOURCECOLUMN is NULL then DESTINATIONCOLUMN = 'NULL'
ELSE DESTINATIONCOLUMN = SOURCECOLUMN
Any help would be greatly appreciated. Thanks.
Start Free Trial
