Hi everyone,
We're trying to migrate a varchar field from Sql2k to varbinary in a sql25k through a dtsx package. We get an error which tell us: "data will be lost".
Does anyone have any idea about that?
Thanks for your time and inputs,
Do it in the extract query, T-SQL supports explicit casts between those two types
DECLARE @.v varchar(10)
SET @.v = '0123456789'
SELECT CAST(@.v AS varbinary(10))
