Unix Technical Forum

Fulltext search on .doc files

This is a discussion on Fulltext search on .doc files within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello All, I am new to SQL Server 2000. I need to load a bunch of (*.doc) word documents ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:42 PM
Rajesh Kapur
 
Posts: n/a
Default Fulltext search on .doc files

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



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:57 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com