> Hi,
> I have an SQL task that returns 3 columns from a select statement (eg,
> Select a, b, c from tableabc). I assign my result set result names 0,
> 1, 2 to three User global variables (which happen to be type string).
> All works fine as long as a, b, c contain values on the tableabc. If
> any column is NULL, however, the SQL task assigns strange characters
> to
> the assigned variable.
> I have a script task following the SQL task that tries to determine if
> any of the a, b, c variables are NULL, but because they get assigned
> with strange characters, they never are.
>
> Is there some workaround for this -- ie, how to avoid the strange
> characters getting assigned to my variables?
>
> Thank you,
>
> Greg
>