Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate"

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 17:37:55 -0000

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@gmail.com> wrote in message news:1108690034.091208.194630@g14g2000cwa.googlegroups.com...
>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.
>

Relevant Pages

  • Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate"
    ... How are you transferring the data? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > database is working fine. ... This DTS package used to work fine for a long ...
    (microsoft.public.sqlserver.replication)
  • Re: Help - DTS Image data to an external file.
    ... Is the data unque for a customer or is it a starter pack of info for your ... You can still distribute a DTS package and export files and have the cutomer ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > What I mean is I need to find a way to get the data into a database that I ...
    (microsoft.public.sqlserver.dts)
  • Re: perl IF DBI::errsrt
    ... >>the tools provided by the database. ... >> databases for backup or for transferring the data to another SQL server ... that inserting the failed record in a error table its ...
    (comp.lang.perl.misc)
  • RE: Executing a DTS package from a Web application.
    ... >> I’ve been only able to find examples of Windows and VB applications. ... >> to a SQL Server database table. ... The SQL Server database is not local. ... the DTS package specifies the full UNC file name. ...
    (microsoft.public.sqlserver.dts)
  • Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate"
    ... Is your DTS package dropping the table each time? ... Looking for a SQL Server replication book? ... > database is working fine. ... > This table is full text on the originating and also on the destination ...
    (microsoft.public.sqlserver.replication)