Tag Info

New answers tagged


Your query actually needs to use two properties of the CONTAINSTABLE function- <maximum distance> and <match_order>. Using CONTAINSTABLE(OpinionDocuments, HTML, 'NEAR((Foo, bar), 0, TRUE)') AS KEY_TBL Specifies to find "Foo" near "Bar" with 0 search objects between (<maximum distance> ", 0,") and in the order specified ...


Instead of using a script component, I recommend using a more database-centric approach. Consider the following approach: Read the data from the flat file using a flat file source. Keep your flat file source simple. It should have one column which contains the EntireRow. (optional) add a script component or derived column to count rows and generate a ...

Top 50 recent answers are included