I am attempting to import data into a SQL Server table from Excel and have trouble with a particular column. The Link column in my Excel source contains a hyperlink and is a unicode string of [DT_WSTR] datatype, the corresponding column in the SQL Server table is defined as varbinary(max) and therefore my dataflow fails.
I've attempted to add a data conversion function as below, to convert string to byte stream [DT_BYTES]
However I can only specify a length of 8000 maximum, which is less than my destination and throws an error
The value could not be converted because of a potential loss of data
I am new to SSIS and am wondering what is the proper way to do this?