I am trying to write a program which will bulk load data from a bcp file into a newly made database on the users PC.
I create the data from an existing DB using SQL-DMO BulkCopy.
I then load it into the users DB using "Bulk Insert " transact SQL.
It all works fine on SQL Server 2000. However on SQL Server 7.0 whenever the .bcp file is being loaded into a table with a field of type decimal, it throws an OLEDB stream error. Even when the .bcp file is empty.
I have tried exporting/importing the data as tab delimited and as native, but it seems to make no difference.
This has really got me stumped and I am running out of time. Can anyone help?
OK I just discovered from the Microsoft web site that there is a bug in SQL Server 7.0. Using Bulk Insert on a table that includes a default value for decimal or numeric data typed fields, throws an error.
There is no solution. It is incurable. The workaround is to "use bcp instead."
Programatically that would be an issue, so i will have to use DMO.