Install it, Configure-it & Run-it…

Please consider this Post-build event

path "C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin"
gacutil /uf "SSISAssemblyExecuter100"
del "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks\SSISAssemblyExecuter100.dll"
copy "C:\your path\bin\Debug\SSISAssemblyExecuter100.dll" "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks\"
gacutil -i "$(TargetDir)SSISAssemblyExecuter100.dll"


First of all, you have to add the component to the ToolBox in the category “Control Flow Items” in the usual way… right click, you choose the “SSIS Control Flow Items”, you search and check “Execute Assembly Task” and the OK button.


Did you see the Icon and Label of the component in the ToolBox?



.. so, drag it into the design surface


Create a file connection… that will point to your assembly file


… and then create a second file connection (optionally – you will add a file connection only if your assembly use a ‘.config’ file)



Double-click on the component already added and you will see the configuration window.

So, choose your connection and then the namespace, the class …


and the method you want to use:


In the grid you can map the “IN” parameters as in the image below


The First column “Parameters” will show you the name of the parameter and its type.

The Second column shows you the parameter direction (IN, OUT, REF)

The Third column is a combobox with the list of System & User defined variables that will be passed as value parameter.

The Forth column (the f(x) column) will allow you to pass an expression only for an IN type parameter. The result (expression text) will be passed in the 3rd column)

If your method will return a value, in the Output value combobox you can specify an Object Type parameter that will receive the returned’s method value.




And… now you can specify a ‘.config’ file used by your assembly. Take a look at this image:



You have two possibilities to specify the path to the .config file:

1. You can choose “Path file connector” (you already created in a previous step - optionally)

2. You can specify an expression as you see in this image:


…and now you can execute the task. Did you obtained the green box?




Last edited Aug 8, 2011 at 10:47 AM by cosminfr, version 12


No comments yet.