I have a database (SQL Server 2000 Enterprise Ed.) with a single table
(Products), which has 3 columns set for Full-Text-Indexing. This
database is working fine. All queries are done through Stored Procs,
and works like a charm.

I tried to copy the database to another database (SQL Server 2000
Personal Ed.) which is on my PC. I have created a DTS package on the
Originating server. This DTS package used to work fine for a long
time, until sometime back few weeks ago I introduced FTI, and now it
does not work.

I get this error when executing DTS package:

"[ODBC SQL Server Driver][SQL Server]Cannot use a CONTAINS or FREETEXT
predicate on table 'Products' because it is not full-text indexed."

This table is full text on the originating and also on the destination
database. (I created one on the destination, thought perhaps that's why
it wouldn't work)

Does anyone know how to fix this? Thanks.

Is your DTS package dropping the table each time? It should merely delete
the data.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

<bikmann (AT) gmail (DOT) com> wrote

DTS package is No dropping the table, and I do remember a while back
seeing data in the Products table. But I will check this again to make
sure and get back.

BTW, I couldn't get to nwsu.com's SQL Server replication book, perhaps
it is blocked on the corporate proxy.

It is also available on Amazon.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

<bikmann (AT) gmail (DOT) com> wrote

Alright, I checked. The DTS is NOT dropping the table in the
destination nor originating. And it is also properly copying the
contents of the Products table into the destination database. But yet
it package will still fail with that message.

How are you transferring the data?
Are you using the Transform Data task or the Transfer Objects task?

If the latter then what options do you have set?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


<bikmann (AT) gmail (DOT) com> wrote

Allan,
I am using "Copy SQL Server Objects Task" to copy the database, with
all the defaults settings.

Personally If I was copying a database I would use BACKUP/RESTORE. I am
not a great fan of the Copy Objects task.

Allan

"Bik" <bikmann (AT) gmail (DOT) com> wrote

DTS allows unattended copy to another running SQL Server. I have used
BACKUP/RESORE, but i wanted to use DTS so that I can put it on
schedule. Currently I have 3 other DBs being copied via DTS, this is
the only one that causes problem., yet it would still copy the table
contents.

You can set up a job to do the BACKUP and restore also unattended.

Allan

"Bik" <bikmann (AT) gmail (DOT) com> wrote