OLE DB provider error 0x80040e21
Posted: Tue Oct 31, 2006 10:38 am
We gota cryptic error from OLE DB stage ( Microsoft SQL server)
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
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