yes, the data source is now the input SQL DB table.

The SSIS project says it writes one record, while testing, but nothing is written, as far as i can tell!

What...

http://sqlblog.com/blogs/greg_low/archive/2008/08/13/modifying-the-thesaurus-in-full-text-search-in-sql-server-2008.aspx

Did you try using the 'Thesaurus' feature ?

Name, Address, City, State, Zip, Phone Number

I do have an SSIS procedure that works very well at extracting emails, but this is more complicated!

eg. I need to search for 'Name'...

It was a Tab.

Thanks guys!

So for TempDb is Raid1 ok, or are you suggesting something else?

Dell had some white papers written that recommended that specific Raid configuration.

Raid0 for TempDB was suggested due to its speed.

I understand what you are saying, but i'm sure they considered...

Current DB size 150 GB, 4 Million records.

Each day i load approx 5000 new records(via bulk insert), with an average size of 30k per record. This could increase to...

I am using seperate RAID for the TempDB (Raid0), Logs(Raid1), Data(Raid10) and Program files(Raid1).

I read in one of the MS technet forums, that you can put the Full text index...

What field type for the FTI field, would provide the best performance?

Thanks

Is there any way to make this query faster?

It seems that each search term i add, makes the query run 6 seconds slower. With five search terms, it takes approx...

When i try to run my app with the updated SP that uses the temp table, i get the following error:

"The return types for the following SP count not be...

The problem only occurs with large volumes of data,...

What do you suggest for phone numbers?

Most of what i have found has been char, varchar or nvarchar.

Thanks!

Thanks Gail 🙂

ps I'm not new to SQL, i have not coded in 20+ years.....old COBOL, CICS, IMS guy.