Skip to Content
0
Mar 22, 2019 at 09:49 PM

Bulkload option in BODS version 14.2

338 Views Last edit Dec 11, 2020 at 01:47 PM 2 rev

Getting following error when trying to use BulkLoad option for a dataflow. If I remove the BulkLoad option, dataflow works fine and target table is loaded without any issues(except that it takes a lot of time). Any idea on how to avoid following error when using BulkLoad option. Version of driver on BODS jobserver(SQL Server Native Client 11.0 version 2011.110.2100.60)

(14.2) 03-21-19 07:07:18 (X) (3604:6708) DBS-070402: |Data flow DF_TRF_PAPremTran_PV|Loader qry_cln_PAPremTran_TRF_PA_PREM_TRAN

ODBC data source <dbdh-test01.pvgroup.intranet> warning message for operation <bcp_sendrow>: <[Microsoft][ODBC SQL Server

Driver]String data, right truncation>, SQLState <22001>.

(14.2) 03-21-19 07:07:18 (W) (3604:6708) DBS-070402: |Data flow DF_TRF_PAPremTran_PV|Loader qry_cln_PAPremTran_TRF_PA_PREM_TRAN

ODBC data source <dbdh-test01.pvgroup.intranet> warning message for operation <bcp_sendrow>: <*****>, SQLState <22001>. This

message contains some internal system details which have been hidden for security. If you need to see the full contents of the

original message, ask your administrator to assign additional privileges to your account.

(14.2) 03-21-19 07:07:18 (W) (3604:6708) RUN-051017: |Data flow DF_TRF_PAPremTran_PV|Loader qry_cln_PAPremTran_TRF_PA_PREM_TRAN

Warning: Bulk loading into table <T> failed with input row data