Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question Bulk load data conversion error

More
04 Jun 2018 10:59 #1 by nikita.barve
nikita.barve created the topic: Bulk load data conversion error
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
Thomas BLETON replied the 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?