Running a FSIS CTS flow from command line

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:

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!

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>