473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Bulk Load Copy - nvarchar is not recognized

3
Hi,
durin importing data via bulk load copy componet appears error 'nvarchar' is not a recognized built-in function name.

I have around 200 xml files and schemas for importing to SQL Server but I have problems with only 3 schemas. They are valid and I don't know reason of this problem.

And next problem , how can I set up in xml schema size of text datatype. After import in MSSQL column has size 1000 chars but I need to change this size higher.In xml schema it doesn't work by defining new data type with higher size.

Any Idea please?
Pablo
Aug 18 '09 #1
2 3915
Delerna
1,134 Expert 1GB
Post the code that contains the error

It seems you are using nvarchar in a way that causes it to be interpreted as a function name and not the correct interpretation as a type.

Thats what the error means
there is no function called nvarchar()

I think the nvarchar type allows up to 8000 characters
someone correct me if I am wrong
Aug 19 '09 #2
pablox
3
Hi Delerna,
I appologize for late answer and thank you ,that you write me too soon. Can you advice me with this problem again?


I have this xml schema:


<!-- schema for importing to MSSQL2005 to database with validating -->

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:element name="root" sql:is-constant="true">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="row" maxOccurs="unbounded" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="row" sql:relation="C_pho"> <!-- table name -->
<xsd:complexType>
<xsd:sequence>
<!-- elements -->
<xsd:element name="ID_OMEZ_PHO" type="xsd:string" minOccurs="0" />
<xsd:element name="ZKRATKA" type="xsd:string" minOccurs="0" />
<xsd:element name="POPIS" type="xsd:string" minOccurs="0" /> <!-- need max except 8000 chars -->
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>



a this code in C#:



bulkLoad = new SQLXMLBulkLoadClass(); ;
bulkLoad.ConnectionString = textBox1.Text;
bulkLoad.ErrorLogFile = Application.ExecutablePath + "importXMLSupport_log.xml";
bulkLoad.KeepIdentity = false;
bulkLoad.SchemaGen = checkBox1.Checked;
bulkLoad.SGDropTables = checkBox1.Checked;


If chekbox1 is checked, I want to create table against xml schema in MSSQL2005.
But, I need nvarchar(max), yes, navarchar allows up to 8000 character or max, what is about 2 giga characters.

Question is: How can I set 'max' in xml schema?

thank for any advice.
Sep 16 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Jim Geissman | last post by:
I am trying to bulk insert a text file. The file has fixed-length fields with no field terminators. BOL says that field terminators are only needed when the data does *not* contain fixed-length...
5
by: me | last post by:
I'm also having problems getting the bulk insert to work. I don't know anything about it except what I've gleened from BOL but I'm not seeming to get anywhere...Hopefully there is some little (or...
2
by: Mike Husler | last post by:
We have created CSV files on HPUX 11.0 and transferred them via ASCII ftp to our SQL Server machine file store to load large amounts for data using the BULK INSERT command. This is the command: ...
9
by: David Rysdam | last post by:
I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an existing script that creates the entire database(s)...
3
by: Tim Satterwhite | last post by:
Hi All, I think this is a thorny problem, and I'm hoping you can help. I've not found this exact issue described anywhere yet. I have a stored procedure that calls BULK INSERT on a set of...
4
by: vicpada | last post by:
Hi all, I am newbie in all the stuff about xml importing into sql server. What I try to do is simple. It is take an xml file and drop it into a table. I am using VS2005, SQLXML 4.0 and...
5
by: yeoj13 | last post by:
Hello, I have a db2load script I'm using to populate a large table. Ideally, my target table is required to have "Not Null" constraints on a number of different columns. I've noticed a ...
0
DTV12345
by: DTV12345 | last post by:
Hello! I have been assigned to bulk-load data into several typed tables of our ODS. I am not clear as to whether it can be done. Here's my homework ===>>> The easy way is to perform INSERT...
2
by: bob.speaking | last post by:
Hi at all, I'm trying to bulk insert a uniqueidentifier column from unicode file. In my file I have guid generated from c# application and they are formatted in this way (separated by "|") : ...
0
by: pablox | last post by:
Hi, durin importing data via bulk load copy componet appears error 'nvarchar' is not a recognized built-in function name. I have around 200 xml files and schemas for importing to SQL Server but...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.