I am trying to load flat file on to Sql Server table. There is one field which has huge data its almost 2000000 bytes. I am extracting this using "LongNVarchar" data type in Datastage and loading into "ntext" datatype column in Sql Server. I am getting below error when i execute
As far as i know ntext can hold upto 1GB of data.ODBC_Connector_22,0: ODBC function "SQLPutData()" reported: SQLSTATE = 22001: Native Error Code = 0: Msg = [Microsoft][ODBC SQL Server Driver]String data, right truncation
ODBC function "SQLPutData()" reported: SQLSTATE = HY000: Native Error Code = 0: Msg = [Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. (CC_OdbcLobSupport::writeLobData, file CC_OdbcLobSupport.cpp, line 167)
ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 42000: Native Error Code = 4,022: Msg = [Microsoft][ODBC SQL Server Driver][SQL Server]Bulk load data was expected but not sent. The batch will be terminated.
ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 01000: Native Error Code = 3,621: Msg = [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 1,237)
Can someone advise on this please