I am trying to deploy content through stand alone deployment. Everything is working fine but when i try to send value(0 or 1) to my column which is "bit" datatype I get following error .
Column: COI_STATUS_IND, literal: 0, Index: 6,Converting '0' to BIT
DBD: Column: COI_ARTICLE_TOOL_FEATURED_IND, literal: 0, Index: 7,Converting '0' to BIT
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: [NBLT0303\DU03]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 7 (""): Data type 0x32 is unknown.
DBD: Vendor Error Code: 8009
DBD: SQL state: 01000
seems like its unable to find datatype. I tried to enter same data through SQL query analyser and it worked.
Any idea what could be reason and solution of it.
DataDeploy - 6.1.1
Database - sql 2005
TS - 6.7.1
win 2k3