Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

import XML file with BCP

Status
Not open for further replies.

DanHD

Technical User
Dec 1, 2008
98
NL
Hello

I try to import a xml file in MSSQL database with the bcp command:

EXEC master..xp_cmdshell 'bcp Database.table in C:\Users\Desktop\test.xml -x -U sa -P password'

I receive the message in sql query results window: Enter the file storage type of field _PRODUCT_CODE [nvarchar(max)]:

This field is the first column in the table and the first field in the file.
How can I proceed?

Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top