varbinary datatype in source

srini.dw · Post by **srini.dw** » Mon Nov 11, 2013 11:49 pm

Hi,

Please need your help to the data issue.

One of the column from the source (SQL server) is [varbinary](max) NULL.

Its having the value as below

0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF

Few values exceed the lenght upto 355902.

Job design
ODBC Connector -> Copy -> DataSet.

What should be datatype of this.

I tried to give as VarBinay as the SQL type and length as 1000000, it says Datatype Not Supported.

Any idea/help please.

Thanks,

prasson_ibm · Post by **prasson_ibm** » Tue Nov 12, 2013 2:45 am

Hi,

Blob datatype is not supported in datastage,but if your target datatype is varchar you can typecast using StringToRaw function.

srini.dw · Post by **srini.dw** » Wed Nov 13, 2013 9:40 pm

Thanks for the reply.

Source column was dropped, we did not carry this forward.

Thanks,