Using a FSIS CTS flow to generate text files and compile as ESP dictionaries
After have some trouble trying while create my FSIS CTS flow, I could finally read the data need from SQL Server instance and push to ESP for indexing, once I got everything working as expected I started to think in what else I could easily to in a CTS flow.
My next challenge was create a ESP dictionary for use on query completion server of ESP, the majority of built in operators doesn’t provide a easy way to do it, hopefully I found the RunCode operator that I can use to perform anything that I need with a custom C# or VB code.
(more…)