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!