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.

image

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

image

 

.. so, drag it into the design surface

Contrl_Flow

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

Connector

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

image 

image

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

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

image

and the method you want to use:

image

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

 image

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.

 

image

 

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

 

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:

image

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

image

 

Enjoy-it!

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

Comments

No comments yet.