Code: Select all
"OLE DB provider error HRESULT=0x80040e21"
while inserting data to if from a data stage job
After a lot of frustration , we entered the same insert statement in SQL server Query analyzer and found that we had an overflow error while loading to a Decimal(9,6) field. Changing the data type to Decimal(15,6) solved the problem.
Im just posting this so that it can be of help to someone in the future
HTH
Thanks