I am using bulk copy in c# to import some data I exported from another SQL server. Everything works fine until I no longer have the internet. During the import it throws an error on all the data types.
I am exporting the data into an XML that includes the schema definition. I then bring that into a DataTable with the schema definition and run SqlBulkCopy.
Why is SQL or c# trying to resolve the microsoft schema on import. The schema came from the sql server?
This app has to work in isolation in some locations and this is a major show stopper. I never thought that SQL could not handle its own schema definition during SqlBulkCopy.
Any help would be much appreciated.
View Complete Post