M
mtakeshi
Guest
i'm using the ODBC driver for Sybase, the connection work fine, but when i enable the bulk load it give me this error "Error: 0x384 at Data Flow Task, ODBC Destination [2]: Open Database Connectivity (ODBC) error occurred. SQLExecute returned error while inserting row 1 Error: 0x384 at Data Flow Task, ODBC Destination [2]: Open Database Connectivity (ODBC) error occurred. state: '42000'. Native Error Code: 0. [DataDirect][ODBC Sybase Wire Protocol driver]Syntax error or access violation." the trace log DtsDebugHost 1b48-a1c ENTER SQLExecute HSTMT 0x00000000001126D0 DtsDebugHost 1b48-a1c EXIT SQLExecute with return code -1 (SQL_ERROR) HSTMT 0x00000000001126D0 DIAG [42000] [DataDirect][ODBC Sybase Wire Protocol driver]Syntax error or access violation. (0) DtsDebugHost 1b48-a1c ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x00000000001126D0 SQLSMALLINT 1 SQLWCHAR * 0x000000001F18E140 SQLINTEGER * 0x000000001F18E134 SQLWCHAR * 0x000000001F18E990 SQLSMALLINT 1024 SQLSMALLINT * 0x000000001F18E130 DtsDebugHost 1b48-a1c EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x00000000001126D0 SQLSMALLINT 1 SQLWCHAR * 0x000000001F18E140 [ 5] "42000" SQLINTEGER * 0x000000001F18E134 (0) SQLWCHAR * 0x000000001F18E990 [ 79] "[DataDirect][ODBC Sybase Wire Protocol driver]Syntax error or access violation." SQLSMALLINT 1024 SQLSMALLINT * 0x000000001F18E130 (79) DtsDebugHost 1b48-a1c ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x00000000001126D0 SQLSMALLINT 2 SQLWCHAR * 0x000000001F18E140 SQLINTEGER * 0x000000001F18E134 SQLWCHAR * 0x000000001F18E990 SQLSMALLINT 1024 SQLSMALLINT * 0x000000001F18E130 DtsDebugHost 1b48-a1c EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 3 SQLHANDLE 0x00000000001126D0 SQLSMALLINT 2 SQLWCHAR * 0x000000001F18E140 SQLINTEGER * 0x000000001F18E134 SQLWCHAR * 0x000000001F18E990 SQLSMALLINT 1024 SQLSMALLINT * 0x000000001F18E130 the config i'm using anyone have a suggestion?
Continue reading...
Continue reading...