get data in BINARY - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

get data in BINARY

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-31 : 08:14:39

hi,

i make "OLE DB FOR Provider DB2"
i create "OLE DB SOURCE" and "OLE DB Destination"
but i get the data in binary like that:

0x404040

what should i do?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-31 : 08:40:29

whats the format in which you want the data to come?

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-31 : 08:56:43

as same in db2,

when i choose "process binary as charcter"
the error is:
"Warning 1
validation warning. Data Flow Task: OLE DB Source [1190]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used."

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-31 : 09:03:20

does data exists as binary in db2?

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-31 : 09:28:05

no,it convert it to binary in the process

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-31 : 09:46:20

whats the source data type?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-31 : 10:36:24

You want 0x404040 to be "@@@" ?

E 12°55'05.63"
N 56°04'39.26"

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-31 : 13:05:52

in the db2 have data ,
when i pull data by "OLE DB Source" In SSIS to "OLE DB Destination" it became in Hexa(no Binaary-the type of fields is binary,and some decimal)

IN SSIS:

1.create Data Source to DB2 By OLE DB Provider to DB2
2.Creeate "OLE DB Source"-choose table
3.Creeate "OLE DB Destination"-Create a new table (when he create table ,he put a binary in the type of some fields and th other he put decimal)

when i execute he bring the data and put them as HEXA.

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-01-01 : 04:09:09

i could not success to upload image

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-01-01 : 05:32:34

i suucess but my data(in my language get in converse except in english)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources