DTS to Oracle tables using columns of type BIT

hi,

does anyone know if it's a bug in sql 2008 when try to do a dts from a table using columns of type bit has value = 1, after finishing in oracle is -1.

example:

create table test (col1 bit)

insert into test values (1)

after performing the dts in oracle becomes as -1

the behavior is correct? in oracle someone would know what kind of sql equivalent of the bit?

 

thanks.

---

marco antônio pinheiro / mcts - database developer 2008 http://marcoantoniopinheiro.blogspot.com se o post foi útil, não esqueça de marcá-lo.

hi marco,

what kind of  oracle column type of  value -1?
bit is  boolean 0 or 1 stored 1 bit of byte. 8-bit columns table may stored in single byte, if not contiguous. bit data cannot null, except microsoft sql server 7.0, null allowed bit data type. mapped number(1) in oracle, bit stored in number(1) (or char). in oracle, possible store bits in char or varchar field (packed) , supply pl/sql functions set / unset / retrieve / query on them.

or you could  customize script in dts add condition when bit 1 ,the number inserted oracle char '1'.

hope helps.

---

best regards,
peja

please remember click "mark answer" on post helps you, , click "unmark answer" if marked post not answer question. can beneficial other community members reading thread.

SQL Server  >  SQL Server Database Engine