SSIS Forge is a tool that can be used to automate the creation of SSIS packages using Powershell. The idea behind SSIS Forge is to use a base SSIS Template to generate all of the required SSIS packages. SSIS Forge can also be used to execute the SSIS packages using Powershell runspaces.
Send me an email or post a comment if you are interested in learning more about SSIS Forge. If there is enough interest I will upload the tool to GitHub.
foreScript is a GUI tool that is used to execute Powershell scripts.
In every Powershell script the creator of the script has to write code to get a set of computer objects, write the actual code that executes against the computer objects, and finally write the code that displays the results of the execution of the code.
The idea behind foreScript is to remove some of this work from the creator of the script so that he/she can concentrate on the Powershell script code that is to be executed against the computer object.
foreScript expects the computer objects input in the format of a range of ip addresses, or a comma separated list of computer names or ip addresses, or a file import, or from either a Windows DHCP Server or a Cisco router and/or switch.
foreScript expects the Powershell script to return objects and will display the output in either the console or as an HTML report. The HTML reports are based on templates.
foreScript also supports the display of custom objects that are actually C# classes using a custom formatter and converters.
foreScript uses json for data exchange and also provides custom variables that can be accessed in the Powershell scripts.
foreScript uses Powershell runspaces, and supports a batch mode for automating the execution of scripts.
foreScript is still evolving and I would like to get feed back on how it can be improved.
Accepts computer objects input in the format of a range of ip addresses, or a comma separated list of computer names or ip addresses, or a file import, or from either a Windows DHCP Server or a Cisco router and/or switch.
WOL - This works by retrieving MAC addresses from a DHCP server (Windows server or Cisco device) and send out WOL packets for each MAC address
The ability to run Powershell scripts in batches using a CSV file as input
Displaying the results of the Powershell script as an HTML report
Authentication via a credential object or impersonation