Posted by – December 23, 2011
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 FAST 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 FAST ESP dictionary for use on query completion server of FAST 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.
Posted by – December 21, 2011
FSIS is a powerfull solution, with CTS you can easily consume and process data to be used on ESP for search or not, recently I wrote a very small powershell script that just run a CTS flow to index database records on ESP.
Here’s how this script looks like:
write-host "`nRunning flow`n" `
Execute-Flow -FlowName MyFlow
write-host "`nFinished running`n" `
And then I just run the script with:
powershell.exe -Command “& c:\scripts\process_database.ps1″
The above command line example can is ready to be used on Task Scheduler, enjoy!