This project is read-only.

Project Description

Launch PowerShell Script/Command from SSIS 2012 (currently targets PowerShell 3.0)

 

1. To install the component, copy the dll file to "C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Tasks\" and launch the PowerShell script from the "Downloads" page)

2. You right -click on "SSIS Toolbox", from the sub-menu you chose "Refresh Toolbox"

3. From SSIS Toolbox you drag-it to Control Flow Worspace 

 

image

When you edit your script you will can use all the string variables declared (by doing a drag & drop from the list):

image

  • You can test your script by clicking on "Run script" button, but keep in mind: Some variables are ,not initialized in design-time, that means that your script will fail. 
  • Eventually, you can get the final result into a variable by choosing a variable you declared 

 

We test:

image

You understood, I’ve just received the result by email

--------------------------------------------------------

So here we are. I've done minimal cleanup, and the code isn't perfect (and there are few comments) but I could not find anything similar online for free and I thought the best thing to do would be to share the code today instead of waiting to polish it before sharing it.

The initial public release is online so everyone should be able to download the code to use (and tweak) on their own.

Note: I'd really appreciate any feedback on whether you think the project isn't feasible, whether you'd like to use it if it were more mature, and that sort of thing. Leave comments or email me at cosmin.vlasiu@gmail.com

Last edited May 17, 2014 at 12:25 PM by cosminfr, version 6