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
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