Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Bulk load data conversion error

More
04 Jun 2018 10:59 #1 by nikita.barve
Bulk load data conversion error was created by nikita.barve
Hello ,

i have created process where data is loaded from query to sql table ,

process execution is conditional where,
1. Monday to Saturday it is insert/update
2 . on sunday its is Truncate load.

but on every Sunday while truncate load it gives me error of "Bulk load data conversion error (type mismatch or invalid character for the specified codepage) "
on sunday






but if same process i am going to run manually by changing condition of truncate load for current day it will work.

on Moday filter:


please help me to resolve this issue.


Regards,
Nikita Barve.
Attachments:
More
04 Jun 2018 12:25 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Bulk load data conversion error
Bulk Load is SqlServer's load utility, it reads a File.
Apparently when trying to read the file, Bulk raised an error related to data at row #2795.
Have you checked sunday's file to see how the data looks around this line number?