Hello All,
I am new to SQL Server 2000. I need to load a bunch of (*.doc) word
documents into image fields to do full text searches on them. I created the
doc_table (below) and tried to bulk insert one word document using the
format file (far below) described in the books on-line. I get the error
"Server: Msg 4829, Level 16, State 1, Line 1 Could not bulk insert. Error
reading destination table column name for source column 1 in format file
'c:\bcp.fmt'."
What am I doing Wrong?
Thanks.
CREATE TABLE [dbo].[doc_table] (
[doc_image] [image] NOT NULL ,
[doc_bind] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[doc_id] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[doc_table] WITH NOCHECK ADD
CONSTRAINT [PK_doc_table] PRIMARY KEY CLUSTERED
(
[doc_id]
) ON [PRIMARY]
GO
=============================
bulk insert doc_table from 'c:\x.doc'
WITH (
FORMATFILE = 'c:\bcp.fmt'
)
=============================
bcp.fmt:
8.0
1
1 SQLIMAGE 0 5578 "" 1 doc_image