Running a FSIS CTS flow from command line
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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | Add-PSSnapin HostControllerPSSnapIn Add-PSSnapin EnginePSSnapin Add-PSSnapin JunoPSSnapin write-host "`nRunning flow`n" ` -foregroundcolor green Connect-System Connect-Engine Execute-Flow -FlowName MyFlow write-host "`nFinished running`n" ` -foregroundcolor green |
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!