Index Services and Sql Server Integration Services

[jswilley]

Sql Server Integration Services offers a term and term frequency task.
These task can be used to filter on noun and noun phrases and then rank
them. Is there a way to leverage Index Services/Index Server so I the
SSIS package doesn't have to scan all the files on a particular server?
I was thinking that Index Services/Server could provide the terms and
SSIS could do the ranking.

[Hilary Cotter]

No. I've worked extensively with the text mining features of SQL Server
including these two components term extraction and term lookup.

The don't filter per se on nouns and noun phrases, rather they build a
dictionary of terms, or nouns and noun phrases and score them according to
overall frequency or per document frequency.

Index Server and Indexing Services does its own ranking and makes no attempt
to 1) identify phrases, 2) identify nouns.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

Post by jswilley
Sql Server Integration Services offers a term and term frequency task.
These task can be used to filter on noun and noun phrases and then rank
them. Is there a way to leverage Index Services/Index Server so I the
SSIS package doesn't have to scan all the files on a particular server?
I was thinking that Index Services/Server could provide the terms and
SSIS could do the ranking.