DSXchange

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,

Hi,

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

Thanks for the reply.

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

Thanks,