Hello,

I extracted xml using "for xml" clause from Production.ProductCategory table in AdventureWorks.

The ModifiedDate is extracted as "1998-06-01T00:00:00".

When I try to load this XML (using BulkLoad) into another sql server instance, I get "Invalid character value for cast specification" error.

My xsd schema looks like this:
What works as the date value:
6/1/8

What else does not work as date value:
1998-06-01T00:00:00Z
1998-06-01T00:00:00.000Z

I would appreciate any pointers.

Regards.

Ash

Hi Ash,

I've had this problem as well. The date going in needs to be in datetime format and 1998-06-01T00:00:00 does not meet that criteria. For example, the following is datetime format:

2009-06-22 20:47:20.427

Try the following: change the value to 1998-06-01 00:00:00 and see if it goes in that way.

Scott

__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

Hi Scott,

Thanks for the reply. I am sorry, I should posted the solution before. You are right, The dates need to exported in any date format which SQL Server natively recognizes. I tried simple mm/dd/yyyy (time was not that important) and it worked.

Regards.

Ash