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.