new index, catalog empty

I have created a FT Index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
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
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> 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
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
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
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>

new custom flat file connection manager component

The standard flat file connection component does not handle flat files with different column counts on different rows. Since that's the type of file I have to read, I like to create a modified version of the flat file connection manager that can do this. I have found some info in how to create a connection manager. But I can't find anything that tels me how to build one that would be recognized by the flat file source dataflow component.

So how do you build an connection manager that can used by the standard flat file source component? Anyone ever did this or knows were to get the docs?

I know my problem is also solvable by reading the row into a single column and then using a script component to split them but that is not the solution I want.

The new connection manager is not going to solve this problem. The parsing logic is not part of the connection manager, it is part of the Flat File source adapter. You would need to build a new source, not connection manager.

Thanks,

Bob