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,
varbinary datatype in source
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Blob datatype is not supported in datastage,but if your target datatype is varchar you can typecast using StringToRaw function.
Blob datatype is not supported in datastage,but if your target datatype is varchar you can typecast using StringToRaw function.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/