Example Project/Package for SQl Server 2005 "Text Extraction"

Does any kind person have a simple example Package for undertaking 'Text Extraction' on one or two columns of text data in a SQL Server table (the data is not in Unicode)?

Check out the sample @. http://aspalliance.com/889
With this example - users will be able to import sample data from a flat file to SQL Server 2005 database.

Let us know if you are looking for any other specific extraction examples.

Thanks,
Loonysan

|||The example provides you provided a useful example of how to set up a package to extract data from an existing flat file. Thank you. Would you per chance have an example on how to set up a package to run on an existing SQL Server table to do a "Text Extraction" on a column of data, including doing an initial conversion to Unicode, as ths appears required?|||

What do you mean by "test extraction"? Are you talking about the TERM EXTRACTION component?

-Jamie

|||

Yes, sorry, "Term Extraction"!

|||

Some Good Pointers for 'Term extraction'

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/datasol.asp (Check out the Example on Extracting Attributes)

http://www.sqlserverdatamining.com/DMCommunity/_Tutorials/688.aspx (Need to register for accessing this site - Registration is Free) - Tutorial on Text Classification using SQL Server 2005.

Thanks,
Loonysan