I'm running a load from DB2 to SQL Server using a DTS
Transformation. I have one field that's going to be the
same for every record so I want to just force it.
Normally I'd just do this: (for example)

Function Main()
DTSDestination("password") = "pwd"
Main = DTSTransformStat_OK
End Function

However the field in SQL Server is Binary.. so a normal
insert would be:

CONVERT(BINARY,'pwd')

How can I get this result in my transformation.. (Using
ActiveXScript) my first instinct was: (but that's mixing
T-SQL with Script.

Function Main()
DTSDestination("password") = CONVERT(BINARY,"pwd")
Main = DTSTransformStat_OK
End Function

Any Help? Thanks!!!